DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_LINES_ALL

Line 885: FROM po_lines_all pol

881: and l_rcv_transaction_rec.rcv_shipment_header_id IS NULL
882: and l_rcv_transaction_rec.item_id IS NOT NULL THEN
883: SELECT item_id
884: INTO l_po_item_id
885: FROM po_lines_all pol
886: WHERE pol.po_line_id = l_po_line_id;
887:
888: IF (l_po_item_id <> l_rcv_transaction_rec.item_id) THEN
889: l_substitute_item_id := l_rcv_transaction_rec.item_id;

Line 2090: FROM po_lines_all

2086:
2087: BEGIN
2088: SELECT nvl(item_revision, '@@@@')
2089: INTO l_item_revision
2090: FROM po_lines_all
2091: WHERE po_line_id = l_rcv_rcpt_rec.po_line_id;
2092:
2093: IF (l_debug = 1) THEN
2094: print_debug('create_po_rcpt_intf_rec: 100.5 l_item_revision='||l_item_revision, 4);

Line 4871: FROM po_lines_all pola

4867: AND lpnc.inventory_item_id = msi.inventory_item_id
4868: AND msi.organization_id = p_organization_id
4869: AND(
4870: lpnc.source_line_id IN(SELECT pola.po_line_id
4871: FROM po_lines_all pola
4872: WHERE pola.po_header_id = NVL(p_po_header_id, pola.po_header_id))
4873: OR lpnc.source_line_id IS NULL
4874: );
4875:

Line 8121: FROM po_lines_all pola

8117: AND (p_lpn_id IS NULL OR lpn.lpn_id=p_lpn_id)
8118: AND lpn.lpn_id = lpnc.parent_lpn_id
8119: AND(
8120: lpnc.source_line_id IN(SELECT pola.po_line_id
8121: FROM po_lines_all pola
8122: WHERE (p_po_header_id IS NULL OR pola.po_header_id=p_po_header_id)
8123: )
8124: OR lpnc.source_line_id IS NULL
8125: );

Line 8138: FROM po_lines_all pola

8134: AND lpn.lpn_id = p_lpn_id
8135: AND lpn.lpn_id = lpnc.parent_lpn_id
8136: AND(
8137: lpnc.source_line_id IN(SELECT pola.po_line_id
8138: FROM po_lines_all pola
8139: WHERE (p_po_header_id IS NULL OR pola.po_header_id=p_po_header_id)
8140: )
8141: OR lpnc.source_line_id IS NULL
8142: );