DBA Data[Home] [Help]

APPS.PO_VENDORMERGE_GRP dependencies on PO_DRAFTS

Line 129: FROM po_drafts dft

125: FROM po_doc_style_headers pods
126: WHERE pods.style_id = pohd.style_id
127: AND NVL(pods.CLM_FLAG,'N') = 'Y')
128: AND EXISTS ( SELECT 'Exclude draft_type is not equal to MOD'
129: FROM po_drafts dft
130: WHERE dft.document_id=pohd.po_header_id
131: AND dft.draft_id= pohd.draft_id
132: AND dft.draft_type='MOD');
133:

Line 148: FROM po_drafts dft

144: WHERE pods.style_id = ph.style_id
145: AND ph.PO_HEADER_ID= pgoa.PO_HEADER_ID
146: AND NVL(pods.CLM_FLAG,'N') = 'Y')
147: AND EXISTS ( SELECT 'Exclude draft_type is not equal to MOD'
148: FROM po_drafts dft
149: WHERE dft.document_id=pgoa.po_header_id
150: AND dft.draft_id= pgoa.draft_id
151: AND dft.draft_type='MOD');
152: --