APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_DRAFTS

Line 2779: po_drafts pd

2775: FROM po_entity_locks pel,
2776: po_multi_mod_docs pmmd,
2777: po_headers_all pha,
2778: po_doc_style_headers pdsh,
2779: po_drafts pd
2780: WHERE pmmd.multi_mod_request_id = p_request_id
2781: AND pha.po_header_id = pmmd.document_id
2782: AND pmmd.document_id = To_Number(pel.entity_pk1)
2783: AND pd.draft_id = pel.lock_by_draft_id

Line 2899: po_drafts pd

2895: po_entity_locks pel,
2896: po_multi_mod_docs pmmd,
2897: po_headers_all pha,
2898: po_doc_style_headers pdsh,
2899: po_drafts pd
2900: WHERE ext.po_header_id = multimod.uda_key_po_header_id
2901: AND ext.draft_id = multimod.uda_key_draft_id
2902: AND ext.attr_group_id = l_addr_attr_group_id
2903: AND multimod.multi_mod_request_id = p_request_id

Line 3003: FROM po_drafts dft

2999: AND pmmd.document_id = pha.po_header_id
3000: AND pha.style_id = pdsh.style_id
3001: AND Nvl(pdsh.conc_mods_enabled_flag, 'N') = 'N'
3002: AND EXISTS (SELECT 'Open Mod Exists'
3003: FROM po_drafts dft
3004: WHERE dft.document_id = pmmd.document_id
3005: AND dft.status IN ('DRAFT', 'IN PROCESS', 'REJECTED', 'SUPPLIER SIGN', 'PRE-APPROVED'));
3006:
3007: d_position := 10;