DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS2 dependencies on PO_HEADERS_INTERFACE

Line 167: FROM po_headers_interface

163: PO_VAL_CONSTANTS.c_document_num_unique
164: FROM DUAL
165: WHERE p_document_num_tbl(i) IS NOT NULL AND --8688769 bug
166: ( EXISTS (SELECT 1
167: FROM po_headers_interface
168: WHERE document_num =p_document_num_tbl(i)
169: AND Nvl(process_code,PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
170: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
171: GROUP BY document_num,org_id HAVING Count(document_num)>1) --14641487 bug