APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_AUCTION_SHIPMENTS_ALL

Line 6025: PON_AUCTION_SHIPMENTS_ALL

6021: --
6022: -- Inseting records
6023: --
6024: INSERT INTO
6025: PON_AUCTION_SHIPMENTS_ALL
6026: ( AUCTION_HEADER_ID,
6027: LINE_NUMBER,
6028: SHIPMENT_NUMBER,
6029: SHIPMENT_TYPE,

Line 6072: FROM PON_AUCTION_SHIPMENTS_ALL

6068: 'N'), -- HAS_PRICE_DIFFERENTIALS_FLAG
6069: decode ( g_auc_doctype_rule_data.ALLOW_PRICE_DIFFERENTIAL,
6070: 'Y', DIFFERENTIAL_RESPONSE_TYPE ,
6071: NULL) -- DIFFERENTIAL_RESPONSE_TYPE
6072: FROM PON_AUCTION_SHIPMENTS_ALL
6073: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
6074: AND SHIPMENT_TYPE = 'PRICE BREAK'
6075: AND line_number >= p_from_line_number
6076: AND line_number <= p_to_line_number) ;

Line 6088: PON_AUCTION_SHIPMENTS_ALL

6084: --
6085: -- Inseting records
6086: --
6087: INSERT INTO
6088: PON_AUCTION_SHIPMENTS_ALL
6089: ( AUCTION_HEADER_ID,
6090: LINE_NUMBER,
6091: SHIPMENT_NUMBER,
6092: SHIPMENT_TYPE,

Line 6123: FROM PON_AUCTION_SHIPMENTS_ALL

6119: p_user_id, -- LAST_UPDATED_BY
6120: p_user_id, -- LAST_UPDATE_LOGIN
6121: MAX_QUANTITY, -- Max Quantity for qty based price tiers
6122: 'N' -- HAS_PRICE_DIFFERENTIALS_FLAG
6123: FROM PON_AUCTION_SHIPMENTS_ALL
6124: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
6125: AND SHIPMENT_TYPE = 'QUANTITY BASED'
6126: AND line_number >= p_from_line_number
6127: AND line_number <= p_to_line_number);