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_ITEM_PRICES_ALL

Line 537: PON_AUCTION_ITEM_PRICES_ALL pai,

533: pbi.line_number bid_line_number,
534: fc.precision fc_precision,
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,

Line 598: PON_AUCTION_ITEM_PRICES_ALL pai,

594: DECODE(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, pbp.worksheet_sequence_number, NULL),
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

Line 1243: PON_AUCTION_ITEM_PRICES_ALL pai,

1239: porg.organization_id porg_proj_exp_organization_id,
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,

Line 1354: pon_auction_item_prices_all pai,

1350: pbps.bid_number,
1351: pbps.bid_line_number,
1352: pbpi.document_disp_line_number
1353: FROM pon_bid_payments_interface pbpi,
1354: pon_auction_item_prices_all pai,
1355: pon_bid_payments_shipments pbps
1356: WHERE pbpi.auction_header_id = pai.auction_header_id
1357: AND pbpi.document_disp_line_number = pai.document_disp_line_number
1358: AND pbps.auction_header_id = pai.auction_header_id

Line 1398: pon_auction_item_prices_all paip,

1394: pbpi.promised_date,
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

Line 1515: PON_AUCTION_ITEM_PRICES_ALL pai

1511: IF l_supplier_enterable_pymt_flag = 'Y' THEN
1512: DELETE FROM PON_BID_PAYMENTS_SHIPMENTS pbp
1513: WHERE pbp.payment_display_number NOT IN (SELECT pbpi.payment_display_number
1514: FROM PON_BID_PAYMENTS_INTERFACE pbpi,
1515: PON_AUCTION_ITEM_PRICES_ALL pai
1516: WHERE pbpi.batch_id = p_batch_id
1517: AND pbpi.bid_number = p_bid_number
1518: AND pai.auction_header_id = pbpi.auction_header_id
1519: AND pai.document_disp_line_number = pbpi.document_disp_line_number

Line 1549: SELECT paip.line_number FROM pon_auction_item_prices_all paip, pon_bid_payments_interface pbpi, pon_bid_payments_shipments pbps WHERE

1545: UPDATE pon_bid_item_prices pbip SET pbip.IS_CHANGED_LINE_FLAG = 'Y',
1546: LAST_UPDATE_DATE = sysdate,
1547: LAST_UPDATED_BY = FND_GLOBAL.user_id
1548: WHERE pbip.line_number IN (
1549: SELECT paip.line_number FROM pon_auction_item_prices_all paip, pon_bid_payments_interface pbpi, pon_bid_payments_shipments pbps WHERE
1550: pbpi.batch_id = p_batch_id AND
1551: paip.auction_header_id = pbpi.auction_header_id AND
1552: pbpi.document_disp_line_number = paip.document_disp_line_number AND
1553: pbps.AUCTION_LINE_NUMBER = paip.line_number AND