APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_LINES

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 1759: , po_lines pol

1755: , NULL secondary_uom_code --OPM Convergence
1756: , pol.secondary_qty secondary_quantity --OPM Convergence* commented out temp
1757: FROM po_headers poh
1758: , po_line_locations poll
1759: , po_lines pol
1760: , po_releases por
1761: , mtl_system_items msi
1762: , mtl_units_of_measure mum
1763: WHERE poll.line_location_id = v_po_line_location_id

Line 2129: --API, then check if there is a item revision stamped on the po lines table and use that

2125:
2126: --Begin bug 4699085
2127: --If the item is not revision controlled ie l_rcv_rcpt_rec.item_rev_control_flag_to = 'N'
2128: --and l_rcv_transaction_rec.item_revision is null, ie p_revision is passed NULL to this
2129: --API, then check if there is a item revision stamped on the po lines table and use that
2130: --revision to pass to QA skip lot API and to the interface record created in RTI to
2131: --process the PO receipt.
2132: IF (l_debug = 1) THEN
2133: print_debug('create_po_rcpt_intf_rec: 100.1 l_rcv_rcpt_rec.item_rev_control_flag_to='||l_rcv_rcpt_rec.item_rev_control_flag_to, 4);

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 4103: , po_lines pol

4099: FROM rcv_shipment_lines rsl
4100: , rcv_shipment_headers rsh
4101: , po_headers poh
4102: , po_line_locations poll
4103: , po_lines pol
4104: , po_releases por
4105: , mtl_system_items msi
4106: , mtl_units_of_measure mum
4107: WHERE NVL(poll.approved_flag, 'N') = 'Y'

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: );