DBA Data[Home] [Help]

APPS.PV_REFERRAL_COMP_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 181: oe_order_headers_all HEADER,

177: SELECT REF.referral_id, REF.partner_id, REF.partner_cust_account_id
178: FROM pv_referrals_b REF,
179: pv_referred_products PROD,
180: pv_ge_benefits_b BENFT,
181: oe_order_headers_all HEADER,
182: oe_order_lines_all LINE,
183: hz_cust_accounts ACCOUNT,
184: mtl_item_categories MIC,
185: eni_prod_denorm_hrchy_v DENORM

Line 235: oe_order_headers_all HEADER,

231: 1 counter
232: FROM pv_referrals_b REF,
233: pv_referred_products PROD,
234: pv_ge_benefits_b BENFT,
235: oe_order_headers_all HEADER,
236: oe_order_lines_all LINE,
237: hz_cust_accounts ACCOUNT,
238: mtl_item_categories MIC,
239: eni_prod_denorm_hrchy_v DENORM

Line 556: oe_order_headers_all HEADER,

552: REF.partner_cust_account_id
553: FROM pv_referrals_b REF,
554: pv_referred_products PROD,
555: pv_ge_benefits_b BENFT,
556: oe_order_headers_all HEADER,
557: oe_order_lines_all LINE,
558: mtl_item_categories MIC,
559: eni_prod_denorm_hrchy_v DENORM,
560: ozf_offers OFFER