DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on PO_DRAFTS

Line 501: FROM po_drafts dft

497: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
498:
499: SELECT Count(1)
500: INTO l_count
501: FROM po_drafts dft
502: WHERE dft.document_id = p_doc_id
503: AND dft.draft_type= 'MOD'
504: AND dft.status IN ('DRAFT', 'IN PROCESS', 'REJECTED', 'SUPPLIER SIGN', 'PRE-APPROVED');
505:

Line 1930: FROM po_drafts dft

1926: po_headers_all pha
1927: WHERE pmmd.multi_mod_request_id = p_req_id
1928: AND pmmd.document_id = pha.po_header_id
1929: AND EXISTS (SELECT 'Open Mod Exists'
1930: FROM po_drafts dft
1931: WHERE dft.document_id = pmmd.document_id
1932: AND dft.status IN ('DRAFT', 'IN PROCESS', 'REJECTED', 'SUPPLIER SIGN', 'PRE-APPROVED')
1933: AND dft.draft_type= 'MOD');
1934: