APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_LINES

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

1706: , NULL secondary_uom_code --OPM Convergence
1707: , pol.secondary_qty secondary_quantity --OPM Convergence* commented out temp
1708: FROM po_headers poh
1709: , po_line_locations poll
1710: , po_lines pol
1711: , po_releases por
1712: , mtl_system_items msi
1713: , mtl_units_of_measure mum
1714: WHERE poll.line_location_id = v_po_line_location_id

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

2072:
2073: --Begin bug 4699085
2074: --If the item is not revision controlled ie l_rcv_rcpt_rec.item_rev_control_flag_to = 'N'
2075: --and l_rcv_transaction_rec.item_revision is null, ie p_revision is passed NULL to this
2076: --API, then check if there is a item revision stamped on the po lines table and use that
2077: --revision to pass to QA skip lot API and to the interface record created in RTI to
2078: --process the PO receipt.
2079: IF (l_debug = 1) THEN
2080: 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 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 3922: , po_lines pol

3918: FROM rcv_shipment_lines rsl
3919: , rcv_shipment_headers rsh
3920: , po_headers poh
3921: , po_line_locations poll
3922: , po_lines pol
3923: , po_releases por
3924: , mtl_system_items msi
3925: , mtl_units_of_measure mum
3926: WHERE NVL(poll.approved_flag, 'N') = 'Y'

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