APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_PARTY_MARKET_SEGMENTS_T

Line 10701: ozf_party_market_segments_t a

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
10702: WHERE
10703: a.market_qualifier_reference = l_territory_id
10704: AND a.market_qualifier_type='TERRITORY'
10705: AND a.site_use_code = 'SHIP_TO'

Line 10723: ozf_party_market_segments_t a

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
10724: WHERE
10725: a.market_qualifier_reference = l_territory_id
10726: AND a.market_qualifier_type='TERRITORY'
10727: AND a.site_use_code = 'SHIP_TO'

Line 10833: ozf_party_market_segments_t a

10829: 'D' account_status_code,
10830: a.market_qualifier_reference territory_id,
10831: a.site_use_id site_use_id
10832: FROM
10833: ozf_party_market_segments_t a
10834: WHERE
10835: a.market_qualifier_type='TERRITORY'
10836: AND a.site_use_code = 'SHIP_TO'
10837: AND a.party_id IS NOT NULL