DBA Data[Home] [Help]

APPS.OKE_DTS_ACTION_PKG dependencies on PO_REQUISITIONS_INTERFACE_ALL

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

369: And D.Inventory_Org_Id = I.Id2(+)
370: And D.K_Line_Id = S.Id
371: And D.Ready_To_Procure = 'Y'
372: And ( D.Po_Ref_1 Is Null
373: Or Exists ( Select 'X' From po_requisitions_interface_all p
374: Where P.Oke_Contract_Deliverable_ID = D.Deliverable_ID
375: And Nvl(P.Process_Flag, 'S') = 'ERROR'
376: And Nvl(P.Batch_ID, 0) = Nvl(D.Po_Ref_1, 0)));
377:

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

420: And D.Inventory_Org_Id = I.Id2(+)
421: And D.K_Line_Id = S.Id
422: And D.Ready_To_Procure = 'Y'
423: And ( D.Po_Ref_1 Is Null
424: Or Exists ( Select 'X' From po_requisitions_interface_all p
425: Where P.Oke_Contract_Deliverable_ID = D.Deliverable_ID
426: And Nvl(P.Process_Flag, 'S') = 'ERROR'
427: And Nvl(P.Batch_ID, 0) = Nvl(D.Po_Ref_1, 0)));
428: