APPS.INV_PROCESS_TEMP dependencies on MTL_TRANSACTION_TYPES

Line 879: FROM MTL_TRANSACTION_TYPES MTTY

875: AND PROCESS_FLAG = 'Y'
876: AND TRANSACTION_STATUS = 3
877: AND EXISTS (
878: SELECT NULL
879: FROM MTL_TRANSACTION_TYPES MTTY
880: WHERE MTTY.TRANSACTION_TYPE_ID = MMTT.TRANSACTION_TYPE_ID
881: AND MTTY.TYPE_CLASS = 1 )
882: AND NOT EXISTS (
883: SELECT NULL

Line 912: FROM MTL_TRANSACTION_TYPES MTTY

908: AND PROCESS_FLAG = 'Y'
909: AND TRANSACTION_STATUS = 3
910: AND EXISTS (
911: SELECT NULL
912: FROM MTL_TRANSACTION_TYPES MTTY
913: WHERE MTTY.TRANSACTION_TYPE_ID = MMTT.TRANSACTION_TYPE_ID
914: AND MTTY.TYPE_CLASS = 1 )
915: AND NOT EXISTS (
916: SELECT NULL

Line 982: FROM MTL_TRANSACTION_TYPES MTTY

978: AND PROCESS_FLAG = 'Y'
979: AND TRANSACTION_STATUS = 3
980: AND EXISTS (
981: SELECT NULL
982: FROM MTL_TRANSACTION_TYPES MTTY
983: WHERE MTTY.TRANSACTION_TYPE_ID = MMTT.TRANSACTION_TYPE_ID
984: AND MTTY.TYPE_CLASS = 1 )
985: AND NOT EXISTS (
986: SELECT NULL

Line 1015: FROM MTL_TRANSACTION_TYPES MTTY

1011: AND PROCESS_FLAG = 'Y'
1012: AND TRANSACTION_STATUS = 3
1013: AND EXISTS (
1014: SELECT NULL
1015: FROM MTL_TRANSACTION_TYPES MTTY
1016: WHERE MTTY.TRANSACTION_TYPE_ID = MMTT.TRANSACTION_TYPE_ID
1017: AND MTTY.TYPE_CLASS = 1 )
1018: AND MMTT.EXPENDITURE_TYPE IS NOT NULL ;
1019: end if;

Line 1047: FROM MTL_TRANSACTION_TYPES MTTY

1043: AND PROCESS_FLAG = 'Y'
1044: AND TRANSACTION_STATUS = 3
1045: AND EXISTS (
1046: SELECT NULL
1047: FROM MTL_TRANSACTION_TYPES MTTY
1048: WHERE MTTY.TRANSACTION_TYPE_ID = MMTT.TRANSACTION_TYPE_ID
1049: AND MTTY.TYPE_CLASS = 1 )
1050: AND NOT EXISTS (
1051: SELECT NULL