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
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
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
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