DBA Data[Home] [Help]

APPS.INV_RCV_TXN_INTERFACE dependencies on PO_LINE_LOCATIONS_ALL

Line 661: from po_line_locations_all pll,

657: , pll.ship_to_location_id
658: , nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
659: , 0 rcv_transaction_id -- only need it for std_deliver
660: , pl.item_revision --only needed for std_deliver
661: from po_line_locations_all pll,
662: po_lines_all pl
663: -- For Bug 7440217
664: , mtl_parameters mp,
665: rcv_parameters rp

Line 734: from po_line_locations_all pll,

730: , v_organization_id NUMBER)
731:
732: IS
733: SELECT COUNT(*)
734: from po_line_locations_all pll,
735: po_lines_all pl
736: -- For Bug 7440217
737: , mtl_parameters mp,
738: rcv_parameters rp

Line 2124: from po_line_locations_all

2120: IF x_qty_rcv_exception_code IN ('REJECT','WARNING') then
2121: BEGIN
2122: select quantity, nvl(qty_rcv_tolerance,0)
2123: into l_poll_qty, l_poll_tolerance_pct
2124: from po_line_locations_all
2125: where line_location_id = temp_cascaded_table(current_n).po_line_location_id ;
2126: EXCEPTION
2127: when others then
2128: NULL;