APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_LINES_ALL

Line 919: FROM po_lines_all pol

915: and l_rcv_transaction_rec.rcv_shipment_header_id IS NULL
916: and l_rcv_transaction_rec.item_id IS NOT NULL THEN
917: SELECT item_id
918: INTO l_po_item_id
919: FROM po_lines_all pol
920: WHERE pol.po_line_id = l_po_line_id;
921:
922: IF (l_po_item_id <> l_rcv_transaction_rec.item_id) THEN
923: l_substitute_item_id := l_rcv_transaction_rec.item_id;

Line 2143: FROM po_lines_all

2139:
2140: BEGIN
2141: SELECT nvl(item_revision, '@@@@')
2142: INTO l_item_revision
2143: FROM po_lines_all
2144: WHERE po_line_id = l_rcv_rcpt_rec.po_line_id;
2145:
2146: IF (l_debug = 1) THEN
2147: print_debug('create_po_rcpt_intf_rec: 100.5 l_item_revision='||l_item_revision, 4);

Line 5139: FROM po_lines_all pola

5135: AND lpnc.inventory_item_id = msi.inventory_item_id
5136: AND msi.organization_id = p_organization_id
5137: AND(
5138: lpnc.source_line_id IN(SELECT pola.po_line_id
5139: FROM po_lines_all pola
5140: WHERE pola.po_header_id = NVL(p_po_header_id, pola.po_header_id))
5141: OR lpnc.source_line_id IS NULL
5142: );
5143:

Line 8517: FROM po_lines_all pola

8513: AND (p_lpn_id IS NULL OR lpn.lpn_id=p_lpn_id)
8514: AND lpn.lpn_id = lpnc.parent_lpn_id
8515: AND(
8516: lpnc.source_line_id IN(SELECT pola.po_line_id
8517: FROM po_lines_all pola
8518: WHERE (p_po_header_id IS NULL OR pola.po_header_id=p_po_header_id)
8519: )
8520: OR lpnc.source_line_id IS NULL
8521: );

Line 8534: FROM po_lines_all pola

8530: AND lpn.lpn_id = p_lpn_id
8531: AND lpn.lpn_id = lpnc.parent_lpn_id
8532: AND(
8533: lpnc.source_line_id IN(SELECT pola.po_line_id
8534: FROM po_lines_all pola
8535: WHERE (p_po_header_id IS NULL OR pola.po_header_id=p_po_header_id)
8536: )
8537: OR lpnc.source_line_id IS NULL
8538: );