DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on CST_PROJ_EXP_TYPES_VAL_V

Line 987: FROM CST_PROJ_EXP_TYPES_VAL_V CET

983: WHERE MTTY.TRANSACTION_TYPE_ID = MMTT.TRANSACTION_TYPE_ID
984: AND MTTY.TYPE_CLASS = 1 )
985: AND NOT EXISTS (
986: SELECT NULL
987: FROM CST_PROJ_EXP_TYPES_VAL_V CET
988: WHERE CET.EXPENDITURE_TYPE = MMTT.EXPENDITURE_TYPE
989: AND CET.COST_ELEMENT_ID = 1
990: AND TRUNC(MMTT.TRANSACTION_DATE) >= CET.SYS_LINK_START_DATE
991: AND TRUNC(MMTT.TRANSACTION_DATE) <= NVL(SYS_LINK_END_DATE,