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 1054: PON_AUCTION_SHIPMENTS_ALL PASA

1050: NVL (sel_price_break_type, g_invalid_string) <> g_none AND
1051: NOT EXISTS (
1052: SELECT 1
1053: FROM
1054: PON_AUCTION_SHIPMENTS_ALL PASA
1055: WHERE
1056: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
1057: PASA.LINE_NUMBER = sel_line_number
1058: )

Line 3065: PON_AUCTION_SHIPMENTS_ALL PASA

3061: PASA.SHIP_TO_ORGANIZATION_ID sel_ship_to_organization_id,
3062: PASA.DIFFERENTIAL_RESPONSE_TYPE sel_differential_response_type
3063: FROM
3064: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3065: PON_AUCTION_SHIPMENTS_ALL PASA
3066: WHERE
3067: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3068: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
3069: PAIP.LINE_NUMBER = PASA.LINE_NUMBER;

Line 3363: PON_AUCTION_SHIPMENTS_ALL PASA

3359: PASA.QUANTITY sel_min_quantity,
3360: PASA.MAX_QUANTITY sel_max_quantity
3361: FROM
3362: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3363: PON_AUCTION_SHIPMENTS_ALL PASA
3364: WHERE
3365: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3366: PASA.AUCTION_HEADER_ID = p_auction_header_id AND
3367: PAIP.LINE_NUMBER = PASA.LINE_NUMBER;

Line 3405: FROM pon_auction_shipments_all pasa1,

3401: FROM pon_auction_item_prices_all paip
3402: WHERE paip.auction_header_id = p_auction_header_id
3403: AND paip.line_number IN
3404: (SELECT DISTINCT pasa.line_number
3405: FROM pon_auction_shipments_all pasa1,
3406: pon_auction_shipments_all pasa
3407: WHERE pasa1.auction_header_id = p_auction_header_id
3408: and pasa.auction_header_id = p_auction_header_id
3409: AND pasa.line_number = pasa1.line_number

Line 3406: pon_auction_shipments_all pasa

3402: WHERE paip.auction_header_id = p_auction_header_id
3403: AND paip.line_number IN
3404: (SELECT DISTINCT pasa.line_number
3405: FROM pon_auction_shipments_all pasa1,
3406: pon_auction_shipments_all pasa
3407: WHERE pasa1.auction_header_id = p_auction_header_id
3408: and pasa.auction_header_id = p_auction_header_id
3409: AND pasa.line_number = pasa1.line_number
3410: AND pasa1.shipment_number <> pasa.shipment_number

Line 3502: PON_AUCTION_SHIPMENTS_ALL PAS

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

Line 3729: PON_AUCTION_SHIPMENTS_ALL PASA,

3725: PPD.SHIPMENT_NUMBER sel_shipment_number,
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

Line 4639: PON_AUCTION_SHIPMENTS_ALL PSA,

4635: PAIP.ITEM_ID SELECTED_ITEM_ID,
4636: PAIP.ITEM_REVISION SELECTED_ITEM_REVISION,
4637: PAIP.LINE_TYPE_ID SELECTED_LINE_TYPE_ID
4638: FROM
4639: PON_AUCTION_SHIPMENTS_ALL PSA,
4640: PON_AUCTION_ITEM_PRICES_ALL PAIP
4641: WHERE
4642: PSA.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
4643: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND

Line 4753: PON_AUCTION_SHIPMENTS_ALL PSA,

4749: PAIP.ITEM_ID SELECTED_ITEM_ID,
4750: PAIP.ITEM_REVISION SELECTED_ITEM_REVISION,
4751: PAIP.LINE_TYPE_ID SELECTED_LINE_TYPE_ID
4752: FROM
4753: PON_AUCTION_SHIPMENTS_ALL PSA,
4754: PON_AUCTION_ITEM_PRICES_ALL PAIP
4755: WHERE
4756: PSA.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
4757: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND

Line 6329: FROM PON_AUCTION_SHIPMENTS_ALL

6325: AND LINE_NUMBER = PAIP.LINE_NUMBER
6326: AND ROWNUM = 1), 'N'),
6327: HAS_SHIPMENTS_FLAG = NVL (
6328: (SELECT 'Y'
6329: FROM PON_AUCTION_SHIPMENTS_ALL
6330: WHERE AUCTION_HEADER_ID = p_auction_header_id
6331: AND shipment_type = 'PRICE BREAK'
6332: AND LINE_NUMBER = PAIP.LINE_NUMBER
6333: AND ROWNUM = 1),'N'),

Line 6357: FROM PON_AUCTION_SHIPMENTS_ALL

6353: AND SHIPMENT_NUMBER = -1
6354: AND ROWNUM = 1),'N'),
6355: HAS_QUANTITY_TIERS = NVL (
6356: (SELECT 'Y'
6357: FROM PON_AUCTION_SHIPMENTS_ALL
6358: WHERE AUCTION_HEADER_ID = p_auction_header_id
6359: AND shipment_type = 'QUANTITY BASED'
6360: AND LINE_NUMBER = PAIP.LINE_NUMBER
6361: AND ROWNUM = 1),'N'),

Line 7076: FROM pon_auction_shipments_all

7072:
7073: -- If the line has any shipments this flag will be Y else N
7074: has_shipments_flag = NVL (
7075: (SELECT 'Y'
7076: FROM pon_auction_shipments_all
7077: WHERE auction_header_id = p_auction_header_id
7078: AND line_number = paip.line_number
7079: AND shipment_type = 'PRICE BREAK'
7080: AND rownum = 1),'N'),

Line 7120: FROM PON_AUCTION_SHIPMENTS_ALL

7116:
7117: --Quantity tiers project - If the line has any quantity based price tiers this flag will be Y else N
7118: has_quantity_tiers = NVL (
7119: (SELECT 'Y'
7120: FROM PON_AUCTION_SHIPMENTS_ALL
7121: WHERE AUCTION_HEADER_ID = p_auction_header_id
7122: AND shipment_type = 'QUANTITY BASED'
7123: AND LINE_NUMBER = PAIP.LINE_NUMBER
7124: AND ROWNUM = 1),'N'),