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 ENI_PROD_DENORM_HRCHY_V

Line 151: eni_prod_denorm_hrchy_v DENORM,

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
155: PROD.referral_id = REF.referral_id AND

Line 185: eni_prod_denorm_hrchy_v DENORM

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
189: REF.order_id IS NULL AND

Line 239: eni_prod_denorm_hrchy_v DENORM

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
243: REF.order_id IS NOT NULL AND

Line 559: eni_prod_denorm_hrchy_v DENORM,

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
563: REF.referral_status IN ('APPROVED', 'MANUAL_EXTEND', 'CLOSED_OPPTY_WON') AND