DBA Data[Home] [Help]

APPS.WMS_WIP_XDOCK_PVT dependencies on WIP_MATERIAL_SHORTAGES_V

Line 100: FROM wip_material_shortages_v w, mtl_txn_request_lines l

96: , w.operation_seq_num
97: , w.wip_issue_flag
98: , w.subinventory_code
99: , w.locator_id
100: FROM wip_material_shortages_v w, mtl_txn_request_lines l
101: WHERE l.lpn_id = l_lpn_id
102: AND l.line_id = NVL(p_move_order_line_id, l.line_id) -- added for ATF_J
103: AND l.organization_id = l_org_id
104: AND w.organization_id = l_org_id

Line 143: FROM wip_material_shortages_v b, mtl_txn_request_lines l

139: INTO l_count
140: FROM DUAL
141: WHERE EXISTS(
142: SELECT 1
143: FROM wip_material_shortages_v b, mtl_txn_request_lines l
144: WHERE l.lpn_id = l_lpn_id
145: AND l.line_id = NVL(p_move_order_line_id, l.line_id) -- added for ATF_J
146: AND l.organization_id = l_org_id
147: AND b.organization_id = l.organization_id