APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_PARTY_MARKET_SEGMENTS_T

Line 10666: ozf_party_market_segments_t a

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
10667: WHERE
10668: a.market_qualifier_reference = l_territory_id
10669: AND a.market_qualifier_type='TERRITORY'
10670: AND a.site_use_code = 'SHIP_TO'

Line 10688: ozf_party_market_segments_t a

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
10689: WHERE
10690: a.market_qualifier_reference = l_territory_id
10691: AND a.market_qualifier_type='TERRITORY'
10692: AND a.site_use_code = 'SHIP_TO'

Line 10798: ozf_party_market_segments_t a

10794: 'D' account_status_code,
10795: a.market_qualifier_reference territory_id,
10796: a.site_use_id site_use_id
10797: FROM
10798: ozf_party_market_segments_t a
10799: WHERE
10800: a.market_qualifier_type='TERRITORY'
10801: AND a.site_use_code = 'SHIP_TO'
10802: AND a.party_id IS NOT NULL