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_VALIDATE_PAYMENTS_INT dependencies on PON_AUCTION_HEADERS_ALL

Line 539: PON_AUCTION_HEADERS_ALL pah,

535: pbh.number_price_decimals pbh_price_precision
536: FROM PON_BID_PAYMENTS_INTERFACE pbp,
537: PON_AUCTION_ITEM_PRICES_ALL pai,
538: PON_BID_ITEM_PRICES pbi,
539: PON_AUCTION_HEADERS_ALL pah,
540: MTL_UNITS_OF_MEASURE uom,
541: PO_LOOKUP_CODES fl,
542: FND_CURRENCIES fc,
543: PON_BID_HEADERS pbh

Line 599: PON_AUCTION_HEADERS_ALL pah

595: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, l_entity_name, NULL) ,
596: p_request_id
597: FROM PON_BID_PAYMENTS_INTERFACE pbp,
598: PON_AUCTION_ITEM_PRICES_ALL pai,
599: PON_AUCTION_HEADERS_ALL pah
600: WHERE pbp.document_disp_line_number = pai.document_disp_line_number
601: AND pbp.auction_header_id = pai.auction_header_id
602: AND pbp.payment_display_number NOT IN(SELECT pap.payment_display_number
603: FROM PON_AUC_PAYMENTS_SHIPMENTS pap

Line 1244: PON_AUCTION_HEADERS_ALL pah,

1240: ship.location_id ship_to_location_id,
1241: fl.lookup_code lookup_payment_type_code
1242: FROM PON_AUC_PAYMENTS_INTERFACE ppi,
1243: PON_AUCTION_ITEM_PRICES_ALL pai,
1244: PON_AUCTION_HEADERS_ALL pah,
1245: PO_SHIP_TO_LOC_ORG_V ship,
1246: FINANCIALS_SYSTEM_PARAMS_ALL fsp,
1247: MTL_UNITS_OF_MEASURE uom,
1248: PO_LOOKUP_CODES fl,

Line 1331: l_supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE;

1327: l_sequence NUMBER :=0;
1328: l_previous_line_number NUMBER := -99;
1329: l_module CONSTANT VARCHAR2(32) := 'COPY_PAYMENTS_FROM_INT_TO_TXN';
1330: l_progress varchar2(200);
1331: l_supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE;
1332:
1333: CURSOR delete_pymt_attachments_cursor IS
1334: SELECT fnd.pk3_value bid_payment_id, -- bid payment id
1335: fnd.pk1_value bid_number, -- bid number

Line 1399: pon_auction_headers_all pah,

1395: pbip.line_number line_number,
1396: nvl(pah.supplier_enterable_pymt_flag,'N') supplier_can_modify_pymts
1397: FROM pon_bid_payments_interface pbpi,
1398: pon_auction_item_prices_all paip,
1399: pon_auction_headers_all pah,
1400: pon_bid_item_prices pbip,
1401: MTL_UNITS_OF_MEASURE uom,
1402: PO_LOOKUP_CODES fl
1403: WHERE pbpi.batch_id = p_batch_id

Line 1508: FROM PON_AUCTION_HEADERS_ALL

1504: ELSE --i.e (p_spreadsheet_type = 'XML')
1505:
1506: SELECT supplier_enterable_pymt_flag
1507: INTO l_supplier_enterable_pymt_flag
1508: FROM PON_AUCTION_HEADERS_ALL
1509: WHERE auction_header_id = p_auction_header_id;
1510:
1511: IF l_supplier_enterable_pymt_flag = 'Y' THEN
1512: DELETE FROM PON_BID_PAYMENTS_SHIPMENTS pbp