DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on PA_ORGANIZATIONS_EXPEND_V

Line 1052: FROM PA_ORGANIZATIONS_EXPEND_V POE

1048: WHERE MTTY.TRANSACTION_TYPE_ID = MMTT.TRANSACTION_TYPE_ID
1049: AND MTTY.TYPE_CLASS = 1 )
1050: AND NOT EXISTS (
1051: SELECT NULL
1052: FROM PA_ORGANIZATIONS_EXPEND_V POE
1053: WHERE POE.ORGANIZATION_ID = MMTT.PA_EXPENDITURE_ORG_ID
1054: AND TRUNC(SYSDATE) BETWEEN POE.DATE_FROM
1055: AND NVL(POE.DATE_TO, TRUNC(SYSDATE)));
1056: /* should we check if txn date is betwe en org active date range ? */