DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on PO_LINES

Line 65: , po_lines pl

61: , rt.unit_of_measure
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')

Line 153: FROM po_lines pol,

149:
150: -- bug 3903136 select the po uom and item id
151: SELECT pol.unit_meas_lookup_code, pol.item_id
152: INTO l_po_uom, l_item_id
153: FROM po_lines pol,
154: po_line_locations pll
155: WHERE pol.po_line_id = pll.po_line_id
156: AND pll.line_location_id = p_po_line_location_id;
157:

Line 2338: po_lines pl

2334: p_ordered,
2335: p_already_billed,
2336: p_po_line_matching_basis
2337: FROM po_line_locations pll,
2338: po_lines pl
2339: WHERE pll.po_line_id = p_po_line_id
2340: AND pl.po_line_id = pll.po_line_id
2341: -- bug fix 6959362 starts
2342: group by pl.matching_basis, pll.shipment_type;