DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_HEADERS_ALL

Line 16079: po_headers_all PH ,

16075: SELECT nvl(sum(nvl(RT.quantity_billed,0)),0)
16076: INTO l_qty_billed_sum
16077: FROM rcv_transactions RT ,
16078: rcv_shipment_headers SH ,
16079: po_headers_all PH ,
16080: po_line_locations_all PS ,
16081: po_releases_all PR ,
16082: per_all_people_f BU
16083: WHERE RT.po_line_location_id = p_invoice_lines_rec.po_line_location_id

Line 21819: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

21815: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21816: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
21817: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
21818:
21819: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21820: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21821:
21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;

Line 23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;

23440: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
23441: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
23442: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
23443: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
23445: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
23446: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
23447: l_uom_code mtl_units_of_measure.uom_code%TYPE;
23448: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;

Line 23446: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

23442: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
23443: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
23445: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
23446: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
23447: l_uom_code mtl_units_of_measure.uom_code%TYPE;
23448: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
23449: l_error_code varchar2(2000);
23450: current_calling_sequence VARCHAR2(2000);

Line 23448: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;

23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
23445: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
23446: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
23447: l_uom_code mtl_units_of_measure.uom_code%TYPE;
23448: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
23449: l_error_code varchar2(2000);
23450: current_calling_sequence VARCHAR2(2000);
23451: l_success boolean;
23452: l_intended_use zx_lines_det_factors.line_intended_use%type;