DBA Data[Home] [Help]

APPS.PO_EDA_IDX_FILE_GEN dependencies on PO_HEADERS_MERGE_V

Line 400: SELECT modification_number CLM_DOCUMENT_NUMBER, 'Y' ismod,MOD_EFFECTIVE_DATE effdate,(select APPROVED_DATE from po_headers_merge_v where

396: (SELECT CLM_DOCUMENT_NUMBER CLM_DOCUMENT_NUMBER, 'N' ismod,CLM_EFFECTIVE_DATE effdate,APPROVED_DATE APPROVED_DATE,CLM_EDAGEN_DATE
397: FROM po_headers_all
398: WHERE uda_template_id IS NOT NULL
399: UNION
400: SELECT modification_number CLM_DOCUMENT_NUMBER, 'Y' ismod,MOD_EFFECTIVE_DATE effdate,(select APPROVED_DATE from po_headers_merge_v where
401: po_header_id = a.DOCUMENT_ID and draft_id = a.DRAFT_ID) APPROVED_DATE,CLM_EDAGEN_DATE
402: FROM po_drafts a)
403: WHERE (decode(P_IS_MOD,'Base Documents','N','Modifications','Y') = ismod or P_IS_MOD = 'Both')
404: AND