DBA Data[Home] [Help]

APPS.OKE_DTS_ACTION_PKG dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 389: Or Exists ( Select 'X' From po_requisitions_interface_all p

385: And D.Inventory_Org_Id = I.Id2(+)
386: And D.K_Line_Id = S.Id
387: And D.Ready_To_Procure = 'Y'
388: And ( D.Po_Ref_1 Is Null
389: Or Exists ( Select 'X' From po_requisitions_interface_all p
390: Where P.Oke_Contract_Deliverable_ID = D.Deliverable_ID
391: And Nvl(P.Process_Flag, 'S') = 'ERROR'
392: And Nvl(P.Batch_ID, 0) = Nvl(D.Po_Ref_1, 0)));
393:

Line 440: Or Exists ( Select 'X' From po_requisitions_interface_all p

436: And D.Inventory_Org_Id = I.Id2(+)
437: And D.K_Line_Id = S.Id
438: And D.Ready_To_Procure = 'Y'
439: And ( D.Po_Ref_1 Is Null
440: Or Exists ( Select 'X' From po_requisitions_interface_all p
441: Where P.Oke_Contract_Deliverable_ID = D.Deliverable_ID
442: And Nvl(P.Process_Flag, 'S') = 'ERROR'
443: And Nvl(P.Batch_ID, 0) = Nvl(D.Po_Ref_1, 0)));
444: