eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_UTIL_PKG dependencies on PO_SESSION_GT

Line 5643: FROM po_session_gt

5639: THEN l_loas
5640: ELSE l_charge_acc
5641: END ) c_l,
5642: CHAR3 Gen_value
5643: FROM po_session_gt
5644: where KEY = l_key)
5645: CONNECT BY NOCYCLE prior acrn=acrn
5646: AND prior Gen_value <> Gen_value
5647: AND prior c_l = c_l

Line 5670: FROM po_session_gt

5666: THEN l_loas
5667: ELSE l_charge_acc
5668: END) c_l,
5669: char5 acrn
5670: FROM po_session_gt
5671: WHERE char5 IS NOT NULL
5672: and KEY = l_key
5673: )-- This part of the sql selects the gen value and identifies it as loa/ca
5674: CONNECT BY NOCYCLE prior gen_val=gen_val

Line 5691: INSERT INTO PO_SESSION_GT

5687:
5688: /*Collecting the Charge Accounts, LOAs and the ACRN values populated
5689: into session gt for validation. */
5690:
5691: INSERT INTO PO_SESSION_GT
5692: (KEY,NUM1,CHAR1,CHAR2,CHAR3,CHAR5)
5693: SELECT L_KEY,
5694: DISTRIBUTION_ID,
5695: CHARGE_ACC,