DBA Data[Home] [Help]

APPS.PV_REFERRAL_COMP_PUB dependencies on OE_ORDER_LINES_ALL

Line 109: FROM oe_order_lines_all

105:
106:
107: CURSOR c_returned_order IS
108: SELECT line_id
109: FROM oe_order_lines_all
110: WHERE flow_status_code = 'RETURNED' AND
111: header_id = p_order_header_id AND
112: line_id = p_order_line_id;
113:

Line 149: oe_order_lines_all LINE,

145: CURSOR c_matching_line (pc_referral_id NUMBER) IS
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

Line 182: oe_order_lines_all LINE,

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
186: WHERE BENFT.additional_info_1 = p_offer_id AND

Line 236: oe_order_lines_all LINE,

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
240: WHERE BENFT.additional_info_1 = :p_offer_id AND

Line 557: oe_order_lines_all LINE,

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