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 2959: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES VL

2955: sum(decode(VL.ENABLED_FLAG,'Y',decode(P.PF_TYPE,'BUYER',1,0),0)) NUM_BUYER_PFS,
2956: 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,
2957: AUCTION_HEADER_ID,
2958: LINE_NUMBER
2959: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES VL
2960: WHERE P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
2961: GROUP BY AUCTION_HEADER_ID, LINE_NUMBER) COUNTER,
2962:
2963: (SELECT COUNT(ATTRIBUTE_NAME) C2,

Line 5072: PON_PRICE_ELEMENT_TYPES_VL VL

5068: p_user_id,
5069: PF_TYPE, -- Tranformation project related column
5070: DISPLAY_TO_SUPPLIERS_FLAG -- Tranformation project related column
5071: FROM PON_PRICE_ELEMENTS P,
5072: PON_PRICE_ELEMENT_TYPES_VL VL
5073: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
5074: AND P.PRICE_ELEMENT_TYPE_ID <> -10
5075: AND P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
5076: AND VL.ENABLED_FLAG = 'Y'

Line 6687: PON_PRICE_ELEMENT_TYPES_VL VL,

6683: p_user_id, -- LAST_UPDATED_BY
6684: p_user_id -- LAST_UPDATE_LOGIN
6685: FROM PON_PF_SUPPLIER_VALUES PPSV,
6686: PON_PRICE_ELEMENTS PPE,
6687: PON_PRICE_ELEMENT_TYPES_VL VL,
6688: PON_BIDDING_PARTIES PBP
6689: WHERE PPSV.AUCTION_HEADER_ID = p_source_auction_header_id AND
6690: PPSV.AUCTION_HEADER_ID = PPE.AUCTION_HEADER_ID AND
6691: PPSV.LINE_NUMBER = PPE.LINE_NUMBER AND

Line 9123: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES_VL VL

9119: DISTINCT VL.NAME
9120: BULK COLLECT
9121: INTO
9122: l_name
9123: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES_VL VL
9124: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
9125: AND P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
9126: AND VL.ENABLED_FLAG = 'N';
9127:

Line 11102: from pon_large_neg_pf_values p, pon_price_element_types_vl vl

11098: p_user_id,
11099: sysdate,
11100: p_user_id,
11101: fnd_global.login_id
11102: from pon_large_neg_pf_values p, pon_price_element_types_vl vl
11103: where
11104: p.auction_header_id = p_source_auction_hdr_id and
11105: p.price_element_type_id = vl.price_element_type_id and
11106: vl.enabled_flag = 'Y' and