DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_HEADERS_ALL

Line 14685: po_headers_all PH ,

14681: SELECT nvl(sum(nvl(RT.quantity_billed,0)),0)
14682: INTO l_qty_billed_sum
14683: FROM rcv_transactions RT ,
14684: rcv_shipment_headers SH ,
14685: po_headers_all PH ,
14686: po_line_locations_all PS ,
14687: po_releases_all PR ,
14688: per_all_people_f BU
14689: WHERE RT.po_line_location_id = p_invoice_lines_rec.po_line_location_id

Line 20014: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

20010: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
20011: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
20012: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
20013:
20014: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
20015: l_uom_code mtl_units_of_measure.uom_code%TYPE;
20016:
20017: l_error_code VARCHAR2(500);
20018: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;

Line 21585: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;

21581: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21582: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21583: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21584: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21585: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
21586: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21587: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21588: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21589: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;

Line 21587: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

21583: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21584: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21585: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
21586: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21587: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21588: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21589: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
21590: l_error_code varchar2(2000);
21591: current_calling_sequence VARCHAR2(2000);

Line 21589: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;

21585: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
21586: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21587: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21588: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21589: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
21590: l_error_code varchar2(2000);
21591: current_calling_sequence VARCHAR2(2000);
21592: l_success boolean;
21593: l_intended_use zx_lines_det_factors.line_intended_use%type;