DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_DOC_STYLE_HEADERS

Line 2778: po_doc_style_headers pdsh,

2774: BULK COLLECT INTO l_document_id_tbl, l_document_num_tbl, l_modification_num_tbl
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)

Line 2898: po_doc_style_headers pdsh,

2894: po_multi_mod_requests multimod,
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

Line 2997: po_doc_style_headers pdsh

2993: SELECT pha.clm_document_number
2994: BULK COLLECT INTO l_document_num_tbl
2995: FROM po_multi_mod_docs pmmd,
2996: po_headers_all pha,
2997: po_doc_style_headers pdsh
2998: WHERE pmmd.multi_mod_request_id = p_request_id
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'