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.PON_NEGOTIATION_COPY_GRP dependencies on PON_PRICE_ELEMENT_TYPES_VL

Line 3849: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES VL

3845: sum(decode(VL.ENABLED_FLAG,'Y',decode(P.PF_TYPE,'BUYER',1,0),0)) NUM_BUYER_PFS,
3846: sum(decode(VL.ENABLED_FLAG,'Y',decode(P.PF_TYPE,'SUPPLIER',decode(P.PRICE_ELEMENT_TYPE_ID,-10,0,1),0),0)) NUM_SUPPLIER_PFS,
3847: AUCTION_HEADER_ID,
3848: LINE_NUMBER
3849: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES VL
3850: WHERE P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
3851: GROUP BY AUCTION_HEADER_ID, LINE_NUMBER) COUNTER,
3852:
3853: (SELECT COUNT(ATTRIBUTE_NAME) C2,

Line 6205: PON_PRICE_ELEMENT_TYPES_VL VL

6201: PF_TYPE, -- Tranformation project related column
6202: DISPLAY_TO_SUPPLIERS_FLAG, -- Tranformation project related column
6203: NEGATIVE_COST_FACTOR_FLAG
6204: FROM PON_PRICE_ELEMENTS P,
6205: PON_PRICE_ELEMENT_TYPES_VL VL
6206: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
6207: AND P.PRICE_ELEMENT_TYPE_ID <> -10
6208: AND P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
6209: AND VL.ENABLED_FLAG = 'Y'

Line 7843: PON_PRICE_ELEMENT_TYPES_VL VL,

7839: p_user_id, -- LAST_UPDATED_BY
7840: p_user_id -- LAST_UPDATE_LOGIN
7841: FROM PON_PF_SUPPLIER_VALUES PPSV,
7842: PON_PRICE_ELEMENTS PPE,
7843: PON_PRICE_ELEMENT_TYPES_VL VL,
7844: PON_BIDDING_PARTIES PBP
7845: WHERE PPSV.AUCTION_HEADER_ID = p_source_auction_header_id AND
7846: PPSV.AUCTION_HEADER_ID = PPE.AUCTION_HEADER_ID AND
7847: PPSV.LINE_NUMBER = PPE.LINE_NUMBER AND

Line 10320: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES_VL VL

10316: DISTINCT VL.NAME
10317: BULK COLLECT
10318: INTO
10319: l_name
10320: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES_VL VL
10321: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
10322: AND P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
10323: AND VL.ENABLED_FLAG = 'N';
10324:

Line 12543: from pon_large_neg_pf_values p, pon_price_element_types_vl vl

12539: p_user_id,
12540: sysdate,
12541: p_user_id,
12542: fnd_global.login_id
12543: from pon_large_neg_pf_values p, pon_price_element_types_vl vl
12544: where
12545: p.auction_header_id = p_source_auction_hdr_id and
12546: p.price_element_type_id = vl.price_element_type_id and
12547: vl.enabled_flag = 'Y' and