DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_AUC_PAYMENTS_SHIPMENTS

Line 2231: FROM pon_bid_item_prices bl,pon_auc_payments_shipments apmt

2227: apmt.PAYMENT_TYPE_CODE, --PAYMENT_TYPE_CODE,
2228: apmt.QUANTITY, --QUANTITY,
2229: apmt.UOM_CODE, --UOM_CODE,
2230: bl.promised_date --PROMISED_DATE,
2231: FROM pon_bid_item_prices bl,pon_auc_payments_shipments apmt
2232: WHERE bl.auction_header_id = p_auc_header_id
2233: AND bl.bid_number = p_bid_number
2234: AND bl.auction_header_id = apmt.auction_header_id
2235: AND bl.line_number = apmt.line_number

Line 2298: pon_auc_payments_shipments apmt

2294: apmt.QUANTITY, --QUANTITY,
2295: apmt.UOM_CODE, --UOM_CODE,
2296: bl.promised_date --PROMISED_DATE,
2297: FROM pon_bid_item_prices bl,
2298: pon_auc_payments_shipments apmt
2299: WHERE bl.auction_header_id = p_auc_header_id
2300: AND bl.bid_number = p_bid_number
2301: AND bl.auction_header_id = apmt.auction_header_id
2302: AND bl.line_number = apmt.line_number

Line 2357: decode(p_supplier_flag ,'N',(select payment_id from pon_auc_payments_shipments

2353: fnd_global.login_id, --LAST_UPDATE_LOGIN
2354: bpmt.PAYMENT_DISPLAY_NUMBER, --PAYMENT_DISPLAY_NUMBER,
2355: bpmt.PAYMENT_DESCRIPTION, --PAYMENT_DESCRIPTION,
2356: decode(p_new_round_or_amended , 'Y' ,
2357: decode(p_supplier_flag ,'N',(select payment_id from pon_auc_payments_shipments
2358: where auction_header_id=p_auc_header_id
2359: AND line_number = bl.line_number
2360: AND payment_display_number= bpmt.PAYMENT_DISPLAY_NUMBER
2361: )