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_PUBLISH_PVT dependencies on PON_PRICE_DIFFERENTIALS

Line 1870: PON_PRICE_DIFFERENTIALS PPD

1866: sel_differential_response_type IS NOT NULL AND
1867: NOT EXISTS (
1868: SELECT 1
1869: FROM
1870: PON_PRICE_DIFFERENTIALS PPD
1871: WHERE
1872: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
1873: PPD.LINE_NUMBER = sel_line_number AND
1874: PPD.SHIPMENT_NUMBER = -1

Line 1913: PON_PRICE_DIFFERENTIALS PPD

1909: sel_differential_response_type IS NULL AND
1910: EXISTS (
1911: SELECT 1
1912: FROM
1913: PON_PRICE_DIFFERENTIALS PPD
1914: WHERE
1915: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
1916: PPD.LINE_NUMBER = sel_line_number AND
1917: PPD.SHIPMENT_NUMBER = -1

Line 3647: FROM PON_PRICE_DIFFERENTIALS PPD

3643: (
3644: sel_differential_response_type IS NOT NULL AND
3645: NOT EXISTS (
3646: SELECT 1
3647: FROM PON_PRICE_DIFFERENTIALS PPD
3648: WHERE
3649: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
3650: PPD.LINE_NUMBER = sel_line_number AND
3651: PPD.SHIPMENT_NUMBER = sel_shipment_number

Line 3687: FROM PON_PRICE_DIFFERENTIALS PPD

3683: (
3684: sel_differential_response_type IS NULL AND
3685: EXISTS (
3686: SELECT 1
3687: FROM PON_PRICE_DIFFERENTIALS PPD
3688: WHERE
3689: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
3690: PPD.LINE_NUMBER = sel_line_number AND
3691: PPD.SHIPMENT_NUMBER = sel_shipment_number

Line 4299: PON_PRICE_DIFFERENTIALS PPD,

4295: p_user_id, -- LAST_UPDATED_BY
4296: sysdate, -- LAST_UPDATE_DATE
4297: p_login_id -- LAST_UPDATE_LOGIN
4298: FROM
4299: PON_PRICE_DIFFERENTIALS PPD,
4300: PON_AUCTION_ITEM_PRICES_ALL PAIP
4301: WHERE
4302: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
4303: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4340: PON_PRICE_DIFFERENTIALS PPD,

4336: p_user_id, -- LAST_UPDATED_BY
4337: sysdate, -- LAST_UPDATE_DATE
4338: p_login_id -- LAST_UPDATE_LOGIN
4339: FROM
4340: PON_PRICE_DIFFERENTIALS PPD,
4341: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4342: PON_AUCTION_SHIPMENTS_ALL PAS
4343: WHERE
4344: PPD.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4474: PON_PRICE_DIFFERENTIALS PPD,

4470: PPDL.PRICE_DIFFERENTIAL_DESC sel_price_differential_desc,
4471: PPD.PRICE_TYPE sel_price_type,
4472: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
4473: FROM
4474: PON_PRICE_DIFFERENTIALS PPD,
4475: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4476: PO_PRICE_DIFF_LOOKUPS_V PPDL
4477: WHERE
4478: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4573: PON_PRICE_DIFFERENTIALS PPD,

4569: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
4570: FROM
4571: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4572: PON_AUCTION_SHIPMENTS_ALL PASA,
4573: PON_PRICE_DIFFERENTIALS PPD,
4574: PO_PRICE_DIFF_LOOKUPS_V PPDL
4575: WHERE
4576: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
4577: PPD.AUCTION_HEADER_ID = p_auction_header_id AND

Line 7208: FROM PON_PRICE_DIFFERENTIALS

7204: AND ROWNUM = 1
7205: AND PF_TYPE = 'BUYER'),'N'),
7206: HAS_PRICE_DIFFERENTIALS_FLAG = NVL (
7207: (SELECT 'Y'
7208: FROM PON_PRICE_DIFFERENTIALS
7209: WHERE AUCTION_HEADER_ID = p_auction_header_id
7210: AND LINE_NUMBER = PAIP.LINE_NUMBER
7211: AND SHIPMENT_NUMBER = -1
7212: AND ROWNUM = 1),'N'),

Line 7994: FROM pon_price_differentials

7990:
7991: -- If the line has any price differentials this flag will be Y else N
7992: has_price_differentials_flag = NVL (
7993: (SELECT 'Y'
7994: FROM pon_price_differentials
7995: WHERE auction_header_id = p_auction_header_id
7996: AND line_number = paip.line_number
7997: AND shipment_number = -1
7998: AND rownum = 1),'N'),