APPS.PO_AUTO_LINE_LOC_PROCESS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 268: FROM po_lines_draft_all

264: --Autocreating a PO that references a GA
265: l_progress := '050';
266: SELECT unit_meas_lookup_code
267: INTO x_po_uom
268: FROM po_lines_draft_all
269: WHERE po_line_id = p_lines.from_line_id_tbl(i)
270: AND draft_id =po_autocreate_params.g_draft_id;
271: EXCEPTION
272: WHEN OTHERS THEN

Line 329: po_lines_draft_all pol --

325: poll.secondary_unit_of_measure --
326: INTO x_line_location_id,
327: x_secondary_unit_of_measure
328: FROM po_line_locations_draft_all poll, --
329: po_lines_draft_all pol --
330: WHERE poll.po_header_id = p_lines.po_header_id_tbl(i)
331: AND pol.draft_id =po_autocreate_params.g_draft_id
332: AND poll.po_line_id = p_lines.po_line_id_tbl(i)
333: AND poll.shipment_num = p_lines.shipment_num_tbl(i)

Line 368: FROM po_lines_draft_all --

364:
365: BEGIN
366: SELECT unit_price
367: INTO x_price
368: FROM po_lines_draft_all --
369: WHERE po_line_id=p_lines.po_line_id_tbl(i)
370: AND draft_id =po_autocreate_params.g_draft_id;
371:
372: EXCEPTION

Line 1180: FROM po_lines_draft_all pol

1176: l_line_unit_price ,
1177: l_line_quantity ,
1178: l_line_amount ,
1179: l_line_purchase_basis
1180: FROM po_lines_draft_all pol
1181: WHERE pol.po_line_id = p_lines.po_line_id_tbl(i)
1182: AND draft_id = po_autocreate_params.g_draft_id;
1183:
1184: d_progress := 30;

Line 1870: FROM po_lines_draft_all pol

1866: --
1867: -- Get value basis from line
1868: SELECT pol.order_type_lookup_code
1869: INTO l_value_basis
1870: FROM po_lines_draft_all pol
1871: WHERE pol.po_line_id = p_lines.po_line_id_tbl(i);
1872:
1873: l_progress := '070';
1874: --