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 5065: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,

5061: SELECT
5062: a.cust_account_id cust_account_id,
5063: a.site_use_id site_use_id,
5064: a.site_use_code site_use_code,
5065: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
5066: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
5067: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5068: a.party_id parent_party_id,
5069: NVL(a.rollup_party_id, a.party_id) rollup_party_id

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

5063: a.site_use_id site_use_id,
5064: a.site_use_code site_use_code,
5065: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
5066: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
5067: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5068: a.party_id parent_party_id,
5069: NVL(a.rollup_party_id, a.party_id) rollup_party_id
5070: FROM
5071: ams_party_market_segments a

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

5080: SELECT
5081: a.cust_account_id cust_account_id,
5082: a.site_use_id site_use_id,
5083: a.site_use_code site_use_code,
5084: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
5085: a.bill_to_site_use_id bill_to_site_use_id,
5086: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5087: a.party_id parent_party_id,
5088: a.rollup_party_id rollup_party_id

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

5082: a.site_use_id site_use_id,
5083: a.site_use_code site_use_code,
5084: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
5085: a.bill_to_site_use_id bill_to_site_use_id,
5086: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
5087: a.party_id parent_party_id,
5088: a.rollup_party_id rollup_party_id
5089: FROM
5090: ams_party_market_segments a

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

6173: SELECT
6174: a.cust_account_id cust_account_id,
6175: a.site_use_id site_use_id,
6176: a.site_use_code site_use_code,
6177: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
6178: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
6179: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6180: a.party_id parent_party_id,
6181: NVL(a.rollup_party_id, a.party_id) rollup_party_id

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

6175: a.site_use_id site_use_id,
6176: a.site_use_code site_use_code,
6177: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
6178: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
6179: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6180: a.party_id parent_party_id,
6181: NVL(a.rollup_party_id, a.party_id) rollup_party_id
6182: FROM
6183: ams_party_market_segments a

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

6192: SELECT
6193: a.cust_account_id cust_account_id,
6194: a.site_use_id site_use_id,
6195: a.site_use_code site_use_code,
6196: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
6197: a.bill_to_site_use_id bill_to_site_use_id,
6198: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6199: a.party_id parent_party_id,
6200: a.rollup_party_id rollup_party_id

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

6194: a.site_use_id site_use_id,
6195: a.site_use_code site_use_code,
6196: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
6197: a.bill_to_site_use_id bill_to_site_use_id,
6198: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
6199: a.party_id parent_party_id,
6200: a.rollup_party_id rollup_party_id
6201: FROM
6202: ams_party_market_segments a

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

9678: SELECT
9679: a.cust_account_id cust_account_id,
9680: a.site_use_id site_use_id,
9681: a.site_use_code site_use_code,
9682: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
9683: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
9684: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
9685: a.party_id parent_party_id,
9686: NVL(a.rollup_party_id, a.party_id) rollup_party_id

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

9680: a.site_use_id site_use_id,
9681: a.site_use_code site_use_code,
9682: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
9683: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
9684: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
9685: a.party_id parent_party_id,
9686: NVL(a.rollup_party_id, a.party_id) rollup_party_id
9687: INTO
9688: p_acct_alloc_rec.cust_account_id,

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

10670: 'A' account_status_code,
10671: ---a.cust_account_id cust_account_id,
10672: a.site_use_id site_use_id
10673: ---a.site_use_code site_use_code,
10674: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10675: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10676: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10677: ---a.party_id parent_party_id,
10678: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id

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

10672: a.site_use_id site_use_id
10673: ---a.site_use_code site_use_code,
10674: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10675: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10676: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10677: ---a.party_id parent_party_id,
10678: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10679: FROM
10680: ams_party_market_segments a

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

10691: 'A' account_status_code,
10692: ---a.cust_account_id cust_account_id,
10693: a.site_use_id site_use_id
10694: ---a.site_use_code site_use_code,
10695: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10696: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10697: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10698: ---a.party_id parent_party_id,
10699: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id

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

10693: a.site_use_id site_use_id
10694: ---a.site_use_code site_use_code,
10695: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10696: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10697: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10698: ---a.party_id parent_party_id,
10699: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10700: FROM
10701: ozf_party_market_segments_t a

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

10713: 'D' account_status_code,
10714: ---a.cust_account_id cust_account_id,
10715: a.site_use_id site_use_id
10716: ---a.site_use_code site_use_code,
10717: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10718: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10719: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10720: ---a.party_id parent_party_id,
10721: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id

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

10715: a.site_use_id site_use_id
10716: ---a.site_use_code site_use_code,
10717: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10718: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10719: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10720: ---a.party_id parent_party_id,
10721: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10722: FROM
10723: ozf_party_market_segments_t a

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

10734: 'D' account_status_code,
10735: ---a.cust_account_id cust_account_id,
10736: a.site_use_id site_use_id
10737: ---a.site_use_code site_use_code,
10738: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10739: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10740: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10741: ---a.party_id parent_party_id,
10742: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id

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

10736: a.site_use_id site_use_id
10737: ---a.site_use_code site_use_code,
10738: ---OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10739: ---NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
10740: ---OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
10741: ---a.party_id parent_party_id,
10742: ---NVL(a.rollup_party_id, a.party_id) rollup_party_id
10743: FROM
10744: ams_party_market_segments a

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

10994: )
10995: = (
10996: SELECT
10997: a.cust_account_id cust_account_id,
10998: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10999: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
11000: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
11001: a.party_id parent_party_id,
11002: NVL(a.rollup_party_id, a.party_id) rollup_party_id

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

10996: SELECT
10997: a.cust_account_id cust_account_id,
10998: OZF_LOCATION_PVT.get_location_id(a.site_use_id) location_id,
10999: NVL(a.bill_to_site_use_id, -9996) bill_to_site_use_id,
11000: OZF_LOCATION_PVT.get_location_id(a.bill_to_site_use_id) bill_to_location_id,
11001: a.party_id parent_party_id,
11002: NVL(a.rollup_party_id, a.party_id) rollup_party_id
11003: FROM
11004: ams_party_market_segments a