DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 3774: from po_requisition_lines_all prl

3770: and (pll.quantity_received < (pll.quantity-pll.quantity_cancelled))
3771: and nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED'
3772: UNION ALL
3773: select 'PO/REQ Linked'
3774: from po_requisition_lines_all prl
3775: where prl.wip_entity_id = p_wip_entity_id
3776: and prl.destination_organization_id = p_org_id
3777: and prl.wip_operation_seq_num = l_job_op_seq_num
3778: and prl.wip_resource_seq_num = l_res_seq_num