Sunday, September 28, 2025

Mathura to Badrinath

Braj to Badri: 10 Days Across Krishna’s Braj, Himalayan Prayags & Kurukshetra

A pilgrimage journal from 15–25 September: Braj’s playfields to Garhwal’s confluences and the epic plains of Kurukshetra.

Gallery placeholder
Use Blogger’s Insert image to add: Badrinath dusk • Prema Mandir night • Devprayag • Brahma Sarovar.
Keep alt-text suggestions from each day below.

Day-by-day journal & significance

15/09 — Gokul & Vrindavan: where it all began

  • Raman Reti (Raman Bihar), Gokul — “Raman” = divine play, “Reti” = sand; a grove revered as Krishna’s childhood playground. Alt: Raman Reti sand grove in Gokul at sunset.
  • Nandababa Bhavan (Chaurasi Khamba), Gokul — The famed 84‑pillared home linked to Nanda Maharaj and Braj’s infancy legends. Alt: Interior pillars of Nand Bhavan (Chaurasi Khamba), Gokul.
  • Brahmand Ghat (Thiruvaipadi) — Where Yashoda is said to have seen the universe in Krishna’s mouth. Alt: Brahmand Ghat on the Yamuna at Gokul.
  • Radha Kund (Govardhan) — Among Braj’s holiest waters, celebrated as the lake of Radha’s love. Alt: Radha Kund steps and temples at Govardhan.
  • Prema Mandir, Vrindavan — Marble temple (2012) famed for night illumination. Alt: Prem Mandir illuminated at night with reflections.

16/09 — Hill towns of Braj

  • Nandagram (Nandgaon) — Hilltop seat of Nanda Baba; temple on Nandishvara Parvat. Alt: Nandgaon temple on hilltop.
  • Barsana — Radha Rani’s hill town; Shriji Temple crowns Bhanugarh. Alt: Barsana Shriji Temple view from steps.
  • Krishna Janmasthala, Mathura — Janmabhoomi complex marking Krishna’s birthplace. Alt: Entrance of Shri Krishna Janmasthan, Mathura.
  • Govardhan Giri — Sacred hill of parikrama and Govardhan‑lila. Alt: Govardhan hill ridge and parikrama path.

17/09 — Vrindavan’s living temples

  • Banke Bihari Temple — Vrindavan’s most thronged shrine (19th c.), associated with Swami Haridas; the curtain is drawn frequently to “rest” the deity. Alt: Banke Bihari Temple facade with devotees.
  • Sri Ranganath (Rangaji) Temple — A rare South‑Indian–style Vaishnava temple dedicated to Goda‑Rangamannar (Andal & Ranganatha). Alt: Rangaji Temple gopuram and water tank.
  • Vrindavan ghats — Yamuna aartis and lanes alive with bhakti music and poetry. Alt: Evening lamps at a Yamuna ghat in Vrindavan.

18/09 — Into the Himalaya

  • Haridwar → Rudraprayag drive — The Alaknanda accompanies the road.
  • Dhari Devi Temple — Guardian deity of Garhwal and protector of Char Dham routes, perched above the Alaknanda. Alt: Dhari Devi shrine above the Alaknanda.
  • Devprayag — Meeting of Bhagirathi and Alaknanda, forming the Ganga; last of the five Prayags downstream. Alt: Turquoise Devprayag confluence from viewpoint.
  • Sangam Ghat — Steps down to the confluence; serene morning shots.

19/09 — Confluences & ancient shrines

  • Rudraprayag → Pipalkoti — River-hugging roads and hanging valleys.
  • Adi Badri — One of the Panch Badri group; early medieval cluster of Vishnu shrines. Alt: Adi Badri temple cluster near Karnaprayag.
  • Karnaprayag — Alaknanda meets the Pindar; site linked to Karna’s penance in lore. Alt: Karnaprayag confluence from bridge.

20/09 — Joshimath & Mana: the gateway

  • Joshimath (Jyotirmath) & Narsingh Temple — Winter seat for Badrinath’s deity when high passes close. Alt: Narsingh Temple at Joshimath, winter seat of Badrinath.
  • (Bhavishya & other ‘Badri’ shrines) — Part of the Panch Badri circuit.
  • Mana Village — “First/Last Indian Village” before the border; classic stops: Vyas Gufa, Ganesh Gufa, Saraswati Mandir, and Bhim Pul over the Saraswati stream. Alt: Bhim Pul natural rock bridge over the Saraswati at Mana.
  • Vasudhara Falls — Longer trek; save for next time.

21/09 — Badrinath (Day 2)

  • Badrinath Temple — Jewel of the Garhwal Char Dham. You attended the Swarna Aarti. Alt: Badrinath Temple lit up at dusk.

22/09 — Upper Alaknanda: confluence & shrines

  • Vridha (Virudha) Badri & Yogadhyan/Yoga Badri — Ancient Vishnu seats at Animath and Pandukeshwar. Alt: Vridha Badri stone shrine in Animath.
  • Vishnuprayag — First of the Panch Prayags: Dhauliganga meets Alaknanda near Joshimath. Alt: Vishnuprayag confluence seen from the roadside temple.
  • Hanuman Chatti — High-road shrine and way‑marker. Alt: Hanuman Chatti shrine with snow peaks behind.

23/09 — Back through the sangams

  • Karnaprayag — Alaknanda + Pindar. Alt: Karnaprayag rivers meeting.
  • Rudraprayag — Alaknanda + Mandakini. Alt: Rudraprayag terraced town and confluence.

24/09 — Haridwar & Rishikesh

  • Haridwar: Mansa Devi (ropeway), Maya Devi (ancient Shakti Peeth), (missed Chandi Devi). Alt: Ropeway gondola up to Mansa Devi, Haridwar.
  • Rishikesh: Triveni Ghat aarti; Janaki (Janki) Setu (2020 suspension bridge); a rudraksha tree and a spatika (crystal) liṅgam along the way. Alt: Evening Ganga aarti lamps at Triveni Ghat, Rishikesh.

25/09 — Kurukshetra: where dharma was taught

  • Brahma Sarovar — One of Asia’s largest man‑made tanks; linked to creation myths. Alt: Brahma Sarovar sunset with temple silhouettes.
  • TTD Sri Venkateswara Temple — A large Tirumala‑run Balaji temple (opened 2018) near the Sarovar. Alt: TTD Venkateswara Temple, Kurukshetra gopuram.
  • Jyotisar (Gita birthplace) — The banyan-shaded site commemorating the Gita discourse. Alt: Banyan tree and chariot tableau at Jyotisar.
  • Bhishma Kund — Commemorates Bhishma teaching the Vishnu Sahasranama. Alt: Bhishma Kund pond with shrine.

Interactive route map

Travel smarts & tips

The Five Prayags (upstream → downstream)

Vishnuprayag (Alaknanda + Dhauliganga) → Nandaprayag (+ Nandakini) → Karnaprayag (+ Pindar) → Rudraprayag (+ Mandakini) → Devprayag (+ Bhagirathi = Ganga).

Panch Badri primer

Badrinath (Vishal Badri), Adi Badri, Vridha (Virudha) Badri, Yoga(dhyān) Badri, Bhavishya Badri — a constellation of Vishnu shrines across the Alaknanda valley.

Don’t‑miss evening moments

  • Prema Mandir light show in Vrindavan.
  • Triveni Ghat Ganga aarti in Rishikesh.
  • Swarna Aarti at Badrinath (bookable).

Practicalities

  • Best season: May–June and Sep–Oct for the Garhwal stretch; monsoon may trigger landslides. Winters: high temples close; Badrinath’s idol shifts to Narsingh Temple, Joshimath.
  • Altitude & health: Hydrate, ascend gradually, keep a buffer day; carry warm layers and a rain shell.
  • Road & safety: Mountain weather changes quickly; check ropeways, road closures, and confluence conditions on the day.
  • Temple etiquette: Modest dress; photography rules vary; phones silent; follow local seva/queue norms.

Sources / further reading

  • Raman Reti – mathura.nic.in/tourist-place/raman-reti-gokul/
  • Nand Bhavan / Chaurasi Khamba – brajrasik.org
  • Radha Kund overview – (general guides)
  • Brahmand Ghat – Times of India travel page
  • Banke Bihari Temple – bihariji.org (official)
  • Sri Rangaji Temple – srirangjimandir.org (official)
  • Dhari Devi – overview pages
  • Devprayag & Panch Prayag – Uttarakhand Tourism
  • Vishnuprayag facts – general references
  • Narsingh Temple (winter seat) – euttaranchal.com
  • Mansa Devi ropeway – udankhatola.com
  • Maya Devi (Incredible India)
  • Triveni Ghat (Incredible India)
  • Janaki Setu 2020 – reference pages
  • Mana – Uttarakhand Tourism
  • Brahma Sarovar – Incredible India
  • TTD Temple Kurukshetra – Times of India coverage
  • Jyotisar – encyclopedia entries

© 2025 Your Name

Tuesday, June 25, 2019

PO Transactions

Oracle APPS Query to get all PO Transactions with PO_Headers_all and PO_lines_all

SELECT
  , mp.organization_code as "Org"
  , poh.segment1 "PO_Number"
  , pol.line_num "Line_Number"
  , pda.DESTINATION_TYPE_CODE "Inv or Expense"
  , msib.segment1  "Item"
  , case
        when msib.description is null
            then 'Non-Inventory'
            else msib.description
    end "Item Description"
  , Round(pol.unit_price * cast
        (
            case
                when conversion_rate is null
                    then 1
                    else conversion_rate
            end as decimal
        )
    , 2) "Unit_Cost"
  , plla.quantity "Ordered Quantity"
  , SUM
        (
            case
                when rct.quantity=0
                    then plla.quantity
                    else rct.quantity
            end
        )
    as "Received_Quantity"
  , CAST(rct.transaction_date as date) "Receipt Date"
  , ROUND ( ( SUM
        (
            case
                when rct.quantity=0
                    then plla.quantity
                    else rct.quantity
            end
        )
    ) * pol.unit_price * cast
        (
            case
                when conversion_rate is null
                    then 1
                    else conversion_rate
            end as decimal
        )
    ,2 )           Spend
  , pv.vendor_name Supplier
  , CAST(poh.CREATION_DATE as  date) "PO_Creation_Date"
  , CAST(plla.need_by_date as  date) "Need By Date"
  , CAST(plla.promised_date as date) "Promised Date"
  , pol.unit_price "Unit_Cost_native"
  , poh.currency_code
  , cast
        (
            case
                when conversion_rate is NULL
                    then 1
                    else conversion_rate
            end as decimal
        )
    "Conversion_Rate"
  , msib.organization_id
  , poh.po_header_id
  , pol.po_line_id
  , pv.vendor_id
FROM
    po_headers_all poh
    inner join
        po_lines_all pol
        on
            poh.po_header_id = pol.po_header_id
    inner join
        po_line_locations_all plla
        on
            plla.po_header_id   = pol.po_header_id
            AND plla.po_line_id = pol.po_line_id
    left outer join
        rcv_transactions rct
        on
            rct.po_header_id            = poh.po_header_id
            and rct.po_line_id          = pol.po_line_id
            and rct.po_line_location_id = plla.line_location_id
    inner join
        po_distributions_all pda
        on
            pda.po_header_id         = poh.po_header_id
            and pda.po_line_id       = pol.po_line_id
            and pda.line_location_id = plla.line_location_id
    left outer join
        mtl_system_items_b msib
        on
            pol.item_id                      = msib.inventory_item_id
            and plla.ship_to_organization_id = msib.organization_id
    inner join
        po_vendors pv
        on
            pv.vendor_id = poh.vendor_id
    left outer join
        mtl_parameters mp
        on
            msib.organization_id = mp.organization_id
    left outer join
        gl_daily_rates gdr
        on
            gdr.from_currency       = poh.currency_code
            and gdr.to_currency     = 'USD'
            and gdr.conversion_date = poh.rate_date
            and gdr.conversion_type = 'Corporate'
WHERE
    poh.po_header_id             = pol.po_header_id
    AND poh.authorization_status = 'APPROVED'
    AND poh.type_lookup_code     = 'STANDARD'
    and
    (
        rct.transaction_type          = 'RECEIVE'
        or rct.transaction_type IS NULL
    )
   group by
    wlv.dc
  , mp.organization_code
  , poh.segment1
  , pol.line_num
  , pda.DESTINATION_TYPE_CODE
  , msib.segment1
  , msib.description
  , Round(pol.unit_price * cast
        (
            case
                when conversion_rate is null
                    then 1
                    else conversion_rate
            end as decimal
        )
    , 2)
  , plla.quantity
  , CAST(rct.transaction_date as date)
  , pv.vendor_name
  , CAST(poh.CREATION_DATE as  date)
  , CAST(plla.need_by_date as  date)
  , CAST(plla.promised_date as date)
  , 'PO'
  , pol.unit_price
  , poh.currency_code
  , cast
        (
            case
                when conversion_rate is NULL
                    then 1
                    else conversion_rate
            end as decimal
        )
  , msib.organization_id
  , poh.po_header_id
  , pol.po_line_id
  , pv.vendor_id