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_AUCTION_SHIPMENTS_ALL

Line 1828: PON_AUCTION_SHIPMENTS_ALL PASA

1824: sel_clm_cost_constraint NOT IN ('NC','NSP') AND -- CLM QA Bug : 9835426
1825: NOT EXISTS (
1826: SELECT 1
1827: FROM
1828: PON_AUCTION_SHIPMENTS_ALL PASA
1829: WHERE
1830: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
1831: PASA.LINE_NUMBER = sel_line_number
1832: )

Line 3903: PON_AUCTION_SHIPMENTS_ALL PASA

3899: PASA.DIFFERENTIAL_RESPONSE_TYPE sel_differential_response_type,
3900: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
3901: FROM
3902: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3903: PON_AUCTION_SHIPMENTS_ALL PASA
3904: WHERE
3905: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3906: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
3907: PAIP.LINE_NUMBER = PASA.LINE_NUMBER;

Line 4202: PON_AUCTION_SHIPMENTS_ALL PASA

4198: PASA.MAX_QUANTITY sel_max_quantity,
4199: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
4200: FROM
4201: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4202: PON_AUCTION_SHIPMENTS_ALL PASA
4203: WHERE
4204: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
4205: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
4206: PAIP.LINE_NUMBER = PASA.LINE_NUMBER;

Line 4244: FROM pon_auction_shipments_all pasa1,

4240: FROM pon_auction_item_prices_all paip
4241: WHERE paip.auction_header_id = p_auction_header_id
4242: AND paip.line_number IN
4243: (SELECT DISTINCT pasa.line_number
4244: FROM pon_auction_shipments_all pasa1,
4245: pon_auction_shipments_all pasa
4246: WHERE pasa1.auction_header_id = p_auction_header_id
4247: and pasa.auction_header_id = p_auction_header_id
4248: AND pasa.line_number = pasa1.line_number

Line 4245: pon_auction_shipments_all pasa

4241: WHERE paip.auction_header_id = p_auction_header_id
4242: AND paip.line_number IN
4243: (SELECT DISTINCT pasa.line_number
4244: FROM pon_auction_shipments_all pasa1,
4245: pon_auction_shipments_all pasa
4246: WHERE pasa1.auction_header_id = p_auction_header_id
4247: and pasa.auction_header_id = p_auction_header_id
4248: AND pasa.line_number = pasa1.line_number
4249: AND pasa1.shipment_number <> pasa.shipment_number

Line 4342: PON_AUCTION_SHIPMENTS_ALL PAS

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
4345: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
4346: PAS.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4572: PON_AUCTION_SHIPMENTS_ALL PASA,

4568: PPDL.PRICE_DIFFERENTIAL_DESC sel_price_differential_desc,
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

Line 5489: PON_AUCTION_SHIPMENTS_ALL PSA,

5485: PAIP.ITEM_REVISION SELECTED_ITEM_REVISION,
5486: PAIP.LINE_TYPE_ID SELECTED_LINE_TYPE_ID,
5487: PAIP.LINE_NUM_DISPLAY
5488: FROM
5489: PON_AUCTION_SHIPMENTS_ALL PSA,
5490: PON_AUCTION_ITEM_PRICES_ALL PAIP
5491: WHERE
5492: PSA.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
5493: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND

Line 5604: PON_AUCTION_SHIPMENTS_ALL PSA,

5600: PAIP.ITEM_REVISION SELECTED_ITEM_REVISION,
5601: PAIP.LINE_TYPE_ID SELECTED_LINE_TYPE_ID,
5602: PAIP.LINE_NUM_DISPLAY
5603: FROM
5604: PON_AUCTION_SHIPMENTS_ALL PSA,
5605: PON_AUCTION_ITEM_PRICES_ALL PAIP
5606: WHERE
5607: PSA.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
5608: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND

Line 7187: FROM PON_AUCTION_SHIPMENTS_ALL

7183: AND LINE_NUMBER = PAIP.LINE_NUMBER
7184: AND ROWNUM = 1), 'N'),
7185: HAS_SHIPMENTS_FLAG = NVL (
7186: (SELECT 'Y'
7187: FROM PON_AUCTION_SHIPMENTS_ALL
7188: WHERE AUCTION_HEADER_ID = p_auction_header_id
7189: AND shipment_type = 'PRICE BREAK'
7190: AND LINE_NUMBER = PAIP.LINE_NUMBER
7191: AND ROWNUM = 1),'N'),

Line 7215: FROM PON_AUCTION_SHIPMENTS_ALL

7211: AND SHIPMENT_NUMBER = -1
7212: AND ROWNUM = 1),'N'),
7213: HAS_QUANTITY_TIERS = NVL (
7214: (SELECT 'Y'
7215: FROM PON_AUCTION_SHIPMENTS_ALL
7216: WHERE AUCTION_HEADER_ID = p_auction_header_id
7217: AND shipment_type = 'QUANTITY BASED'
7218: AND LINE_NUMBER = PAIP.LINE_NUMBER
7219: AND ROWNUM = 1),'N'),

Line 7967: FROM pon_auction_shipments_all

7963:
7964: -- If the line has any shipments this flag will be Y else N
7965: has_shipments_flag = NVL (
7966: (SELECT 'Y'
7967: FROM pon_auction_shipments_all
7968: WHERE auction_header_id = p_auction_header_id
7969: AND line_number = paip.line_number
7970: AND shipment_type = 'PRICE BREAK'
7971: AND rownum = 1),'N'),

Line 8011: FROM PON_AUCTION_SHIPMENTS_ALL

8007:
8008: --Quantity tiers project - If the line has any quantity based price tiers this flag will be Y else N
8009: has_quantity_tiers = NVL (
8010: (SELECT 'Y'
8011: FROM PON_AUCTION_SHIPMENTS_ALL
8012: WHERE AUCTION_HEADER_ID = p_auction_header_id
8013: AND shipment_type = 'QUANTITY BASED'
8014: AND LINE_NUMBER = PAIP.LINE_NUMBER
8015: AND ROWNUM = 1),'N'),