DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on PO_LINE_TYPES

Line 66: , po_line_types lt

62: , lt.matching_basis
63: FROM rcv_transactions rt
64: , rcv_shipment_headers sh
65: , po_lines pl
66: , po_line_types lt
67: WHERE sh.receipt_source_code = 'VENDOR'
68: AND rt.shipment_header_id = sh.shipment_header_id
69: AND rt.transaction_type IN ('RECEIVE','MATCH')
70: AND rt.po_line_id = pl.po_line_id

Line 104: l_match_basis PO_LINE_TYPES.MATCHING_BASIS%TYPE;

100: l_rejected_txn_qty NUMBER;
101: l_matching_error VARCHAR2(2000);
102: debug_info VARCHAR2(2000);
103:
104: l_match_basis PO_LINE_TYPES.MATCHING_BASIS%TYPE;
105: l_ordered_amt NUMBER;
106: l_received_amt NUMBER;
107: l_delivered_amt NUMBER;
108: l_cancelled_amt NUMBER;