DBA Data[Home] [Help]

APPS.PV_REFERRAL_COMP_PUB dependencies on MTL_ITEM_CATEGORIES

Line 150: mtl_item_categories MIC,

146: SELECT LINE.inventory_item_id
147: FROM pv_referred_products PROD,
148: pv_referrals_b REF,
149: oe_order_lines_all LINE,
150: mtl_item_categories MIC,
151: eni_prod_denorm_hrchy_v DENORM,
152: pv_ge_benefits_vl BENFT
153: WHERE REF.referral_id = pc_referral_id AND
154: REF.referral_status IN ('APPROVED', 'MANUAL_EXTEND', 'CLOSED_OPPTY_WON') AND

Line 184: mtl_item_categories MIC,

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
186: WHERE BENFT.additional_info_1 = p_offer_id AND
187: BENFT.benefit_id = REF.benefit_id AND
188: REF.referral_id = PROD.referral_id AND

Line 238: mtl_item_categories MIC,

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
240: WHERE BENFT.additional_info_1 = :p_offer_id AND
241: BENFT.benefit_id = REF.benefit_id AND
242: REF.referral_id = PROD.referral_id AND

Line 558: mtl_item_categories MIC,

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
561: WHERE REF.referral_id = pc_referral_id AND
562: BENFT.benefit_id = REF.benefit_id AND