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 1095: PON_PRICE_DIFFERENTIALS PPD

1091: sel_differential_response_type IS NOT NULL AND
1092: NOT EXISTS (
1093: SELECT 1
1094: FROM
1095: PON_PRICE_DIFFERENTIALS PPD
1096: WHERE
1097: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
1098: PPD.LINE_NUMBER = sel_line_number AND
1099: PPD.SHIPMENT_NUMBER = -1

Line 1137: PON_PRICE_DIFFERENTIALS PPD

1133: sel_differential_response_type IS NULL AND
1134: EXISTS (
1135: SELECT 1
1136: FROM
1137: PON_PRICE_DIFFERENTIALS PPD
1138: WHERE
1139: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
1140: PPD.LINE_NUMBER = sel_line_number AND
1141: PPD.SHIPMENT_NUMBER = -1

Line 2810: FROM PON_PRICE_DIFFERENTIALS PPD

2806: (
2807: sel_differential_response_type IS NOT NULL AND
2808: NOT EXISTS (
2809: SELECT 1
2810: FROM PON_PRICE_DIFFERENTIALS PPD
2811: WHERE
2812: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
2813: PPD.LINE_NUMBER = sel_line_number AND
2814: PPD.SHIPMENT_NUMBER = sel_shipment_number

Line 2850: FROM PON_PRICE_DIFFERENTIALS PPD

2846: (
2847: sel_differential_response_type IS NULL AND
2848: EXISTS (
2849: SELECT 1
2850: FROM PON_PRICE_DIFFERENTIALS PPD
2851: WHERE
2852: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
2853: PPD.LINE_NUMBER = sel_line_number AND
2854: PPD.SHIPMENT_NUMBER = sel_shipment_number

Line 3460: PON_PRICE_DIFFERENTIALS PPD,

3456: p_user_id, -- LAST_UPDATED_BY
3457: sysdate, -- LAST_UPDATE_DATE
3458: p_login_id -- LAST_UPDATE_LOGIN
3459: FROM
3460: PON_PRICE_DIFFERENTIALS PPD,
3461: PON_AUCTION_ITEM_PRICES_ALL PAIP
3462: WHERE
3463: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
3464: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 3500: PON_PRICE_DIFFERENTIALS PPD,

3496: p_user_id, -- LAST_UPDATED_BY
3497: sysdate, -- LAST_UPDATE_DATE
3498: p_login_id -- LAST_UPDATE_LOGIN
3499: FROM
3500: PON_PRICE_DIFFERENTIALS PPD,
3501: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3502: PON_AUCTION_SHIPMENTS_ALL PAS
3503: WHERE
3504: PPD.AUCTION_HEADER_ID = p_auction_header_id AND

Line 3632: PON_PRICE_DIFFERENTIALS PPD,

3628: PPD.PRICE_DIFFERENTIAL_NUMBER sel_price_differential_number,
3629: PPDL.PRICE_DIFFERENTIAL_DESC sel_price_differential_desc,
3630: PPD.PRICE_TYPE sel_price_type
3631: FROM
3632: PON_PRICE_DIFFERENTIALS PPD,
3633: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3634: PO_PRICE_DIFF_LOOKUPS_V PPDL
3635: WHERE
3636: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 3730: PON_PRICE_DIFFERENTIALS PPD,

3726: PPDL.PRICE_DIFFERENTIAL_DESC sel_price_differential_desc
3727: FROM
3728: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3729: PON_AUCTION_SHIPMENTS_ALL PASA,
3730: PON_PRICE_DIFFERENTIALS PPD,
3731: PO_PRICE_DIFF_LOOKUPS_V PPDL
3732: WHERE
3733: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3734: PPD.AUCTION_HEADER_ID = p_auction_header_id AND

Line 6350: FROM PON_PRICE_DIFFERENTIALS

6346: AND ROWNUM = 1
6347: AND PF_TYPE = 'BUYER'),'N'),
6348: HAS_PRICE_DIFFERENTIALS_FLAG = NVL (
6349: (SELECT 'Y'
6350: FROM PON_PRICE_DIFFERENTIALS
6351: WHERE AUCTION_HEADER_ID = p_auction_header_id
6352: AND LINE_NUMBER = PAIP.LINE_NUMBER
6353: AND SHIPMENT_NUMBER = -1
6354: AND ROWNUM = 1),'N'),

Line 7103: FROM pon_price_differentials

7099:
7100: -- If the line has any price differentials this flag will be Y else N
7101: has_price_differentials_flag = NVL (
7102: (SELECT 'Y'
7103: FROM pon_price_differentials
7104: WHERE auction_header_id = p_auction_header_id
7105: AND line_number = paip.line_number
7106: AND shipment_number = -1
7107: AND rownum = 1),'N'),