eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_REFERRAL_COMP_PUB dependencies on PV_REFERRED_PRODUCTS

Line 147: FROM pv_referred_products PROD,

143: -- 'APPROVED', 'MANUAL_EXTEND', and 'CLOSED_OPPTY_WON'.
144: -- -------------------------------------------------------------------
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,

Line 179: pv_referred_products PROD,

175: SELECT *
176: FROM (
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,

Line 233: pv_referred_products PROD,

229: REF.partner_cust_account_id,
230: REF.claim_id,
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,

Line 554: pv_referred_products PROD,

550: OFFER.qp_list_header_id,
551: REF.referral_id,
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,