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.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_LOCATION_PVT

Line 5038: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

5034: SELECT
5035: a.cust_account_id cust_account_id,
5036: a.site_use_id site_use_id,
5037: a.site_use_code site_use_code,
5038: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
5039: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
5040: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5041: a.party_id parent_party_id,
5042: NVL(a.rollup_party_id, a.party_id) rollup_party_id

Line 5040: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

5036: a.site_use_id site_use_id,
5037: a.site_use_code site_use_code,
5038: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
5039: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
5040: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5041: a.party_id parent_party_id,
5042: NVL(a.rollup_party_id, a.party_id) rollup_party_id
5043: FROM
5044: ams_party_market_segments a

Line 5057: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

5053: SELECT
5054: a.cust_account_id cust_account_id,
5055: a.site_use_id site_use_id,
5056: a.site_use_code site_use_code,
5057: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
5058: a.bill_to_site_use_id bill_to_site_use_id,
5059: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5060: a.party_id parent_party_id,
5061: a.rollup_party_id rollup_party_id

Line 5059: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

5055: a.site_use_id site_use_id,
5056: a.site_use_code site_use_code,
5057: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
5058: a.bill_to_site_use_id bill_to_site_use_id,
5059: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5060: a.party_id parent_party_id,
5061: a.rollup_party_id rollup_party_id
5062: FROM
5063: ams_party_market_segments a

Line 6148: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

6144: SELECT
6145: a.cust_account_id cust_account_id,
6146: a.site_use_id site_use_id,
6147: a.site_use_code site_use_code,
6148: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
6149: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
6150: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6151: a.party_id parent_party_id,
6152: NVL(a.rollup_party_id, a.party_id) rollup_party_id

Line 6150: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

6146: a.site_use_id site_use_id,
6147: a.site_use_code site_use_code,
6148: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
6149: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
6150: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6151: a.party_id parent_party_id,
6152: NVL(a.rollup_party_id, a.party_id) rollup_party_id
6153: FROM
6154: ams_party_market_segments a

Line 6167: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

6163: SELECT
6164: a.cust_account_id cust_account_id,
6165: a.site_use_id site_use_id,
6166: a.site_use_code site_use_code,
6167: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
6168: a.bill_to_site_use_id bill_to_site_use_id,
6169: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6170: a.party_id parent_party_id,
6171: a.rollup_party_id rollup_party_id

Line 6169: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

6165: a.site_use_id site_use_id,
6166: a.site_use_code site_use_code,
6167: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
6168: a.bill_to_site_use_id bill_to_site_use_id,
6169: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6170: a.party_id parent_party_id,
6171: a.rollup_party_id rollup_party_id
6172: FROM
6173: ams_party_market_segments a

Line 9647: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

9643: SELECT
9644: a.cust_account_id cust_account_id,
9645: a.site_use_id site_use_id,
9646: a.site_use_code site_use_code,
9647: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
9648: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
9649: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
9650: a.party_id parent_party_id,
9651: NVL(a.rollup_party_id, a.party_id) rollup_party_id

Line 9649: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

9645: a.site_use_id site_use_id,
9646: a.site_use_code site_use_code,
9647: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
9648: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
9649: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
9650: a.party_id parent_party_id,
9651: NVL(a.rollup_party_id, a.party_id) rollup_party_id
9652: INTO
9653: p_acct_alloc_rec.cust_account_id,

Line 10639: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

10635: 'A' account_status_code,
10636: ---a.cust_account_id cust_account_id,
10637: a.site_use_id site_use_id
10638: ---a.site_use_code site_use_code,
10639: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10640: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10641: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10642: ---a.party_id parent_party_id,
10643: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id

Line 10641: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

10637: a.site_use_id site_use_id
10638: ---a.site_use_code site_use_code,
10639: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10640: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10641: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10642: ---a.party_id parent_party_id,
10643: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10644: FROM
10645: ams_party_market_segments a

Line 10660: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

10656: 'A' account_status_code,
10657: ---a.cust_account_id cust_account_id,
10658: a.site_use_id site_use_id
10659: ---a.site_use_code site_use_code,
10660: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10661: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10662: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10663: ---a.party_id parent_party_id,
10664: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id

Line 10662: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

10658: a.site_use_id site_use_id
10659: ---a.site_use_code site_use_code,
10660: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10661: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10662: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10663: ---a.party_id parent_party_id,
10664: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10665: FROM
10666: ozf_party_market_segments_t a

Line 10682: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

10678: 'D' account_status_code,
10679: ---a.cust_account_id cust_account_id,
10680: a.site_use_id site_use_id
10681: ---a.site_use_code site_use_code,
10682: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10683: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10684: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10685: ---a.party_id parent_party_id,
10686: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id

Line 10684: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

10680: a.site_use_id site_use_id
10681: ---a.site_use_code site_use_code,
10682: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10683: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10684: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10685: ---a.party_id parent_party_id,
10686: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10687: FROM
10688: ozf_party_market_segments_t a

Line 10703: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

10699: 'D' account_status_code,
10700: ---a.cust_account_id cust_account_id,
10701: a.site_use_id site_use_id
10702: ---a.site_use_code site_use_code,
10703: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10704: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10705: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10706: ---a.party_id parent_party_id,
10707: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id

Line 10705: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

10701: a.site_use_id site_use_id
10702: ---a.site_use_code site_use_code,
10703: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10704: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10705: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10706: ---a.party_id parent_party_id,
10707: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10708: FROM
10709: ams_party_market_segments a

Line 10963: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

10959: )
10960: = (
10961: SELECT
10962: a.cust_account_id cust_account_id,
10963: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10964: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10965: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10966: a.party_id parent_party_id,
10967: NVL(a.rollup_party_id, a.party_id) rollup_party_id

Line 10965: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,

10961: SELECT
10962: a.cust_account_id cust_account_id,
10963: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10964: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10965: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10966: a.party_id parent_party_id,
10967: NVL(a.rollup_party_id, a.party_id) rollup_party_id
10968: FROM
10969: ams_party_market_segments a