DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 3779: from po_requisition_lines_all prl

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