APPS.INV_TXN_MANAGER_GRP dependencies on MTL_TRANSACTION_TYPES

Line 1895: FROM MTL_TRANSACTION_TYPES MTT

1891: LAST_UPDATE_LOGIN = p_loginid,
1892: PROGRAM_UPDATE_DATE = SYSDATE,
1893: TRANSACTION_ACTION_ID =
1894: (SELECT MTT.TRANSACTION_ACTION_ID
1895: FROM MTL_TRANSACTION_TYPES MTT
1896: WHERE MTT.TRANSACTION_TYPE_ID
1897: = MTI.TRANSACTION_TYPE_ID),
1898: TRANSACTION_SOURCE_TYPE_ID =
1899: (SELECT MTT.TRANSACTION_SOURCE_TYPE_ID

Line 1900: FROM MTL_TRANSACTION_TYPES MTT

1896: WHERE MTT.TRANSACTION_TYPE_ID
1897: = MTI.TRANSACTION_TYPE_ID),
1898: TRANSACTION_SOURCE_TYPE_ID =
1899: (SELECT MTT.TRANSACTION_SOURCE_TYPE_ID
1900: FROM MTL_TRANSACTION_TYPES MTT
1901: WHERE MTT.TRANSACTION_TYPE_ID
1902: = MTI.TRANSACTION_TYPE_ID)
1903: WHERE TRANSACTION_HEADER_ID = p_header_id
1904: AND PROCESS_FLAG = 1;

Line 2738: FROM MTL_TRANSACTION_TYPES MTT

2734: WHERE TRANSACTION_HEADER_ID = p_header_id
2735: AND PROCESS_FLAG = 1
2736: AND NOT EXISTS (
2737: SELECT NULL
2738: FROM MTL_TRANSACTION_TYPES MTT
2739: WHERE MTT.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
2740: AND nvl(MTT.DISABLE_DATE,SYSDATE+1) > SYSDATE );
2741:
2742: l_count := SQL%ROWCOUNT;

Line 3470: FROM MTL_TRANSACTION_TYPES MTTY

3466: AND TRANSACTION_ACTION_ID IN (1, 27 )
3467: AND PROCESS_FLAG = 1
3468: AND EXISTS (
3469: SELECT NULL
3470: FROM MTL_TRANSACTION_TYPES MTTY
3471: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
3472: AND MTTY.TYPE_CLASS = 1 )
3473: AND NOT EXISTS (
3474: SELECT NULL

Line 3525: FROM MTL_TRANSACTION_TYPES MTTY

3521: AND TRANSACTION_ACTION_ID IN (1, 27 )
3522: AND PROCESS_FLAG = 1
3523: AND EXISTS (
3524: SELECT NULL
3525: FROM MTL_TRANSACTION_TYPES MTTY
3526: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
3527: AND MTTY.TYPE_CLASS = 1 )
3528: AND NOT EXISTS (
3529: SELECT NULL

Line 3559: FROM MTL_TRANSACTION_TYPES MTTY

3555: AND TRANSACTION_ACTION_ID IN (1, 27 )
3556: AND PROCESS_FLAG = 1
3557: AND EXISTS (
3558: SELECT NULL
3559: FROM MTL_TRANSACTION_TYPES MTTY
3560: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
3561: AND MTTY.TYPE_CLASS = 1 )
3562: AND MTI.EXPENDITURE_TYPE IS NOT NULL ;
3563:

Line 6424: FROM MTL_TRANSACTION_TYPES MTTY

6420: AND TRANSACTION_ACTION_ID IN (1, 27 )
6421: AND PROCESS_FLAG = 1
6422: AND EXISTS (
6423: SELECT null
6424: FROM MTL_TRANSACTION_TYPES MTTY
6425: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
6426: AND MTTY.TYPE_CLASS = 1 )
6427: AND NOT EXISTS (
6428: SELECT null

Line 6481: FROM MTL_TRANSACTION_TYPES MTTY

6477: AND TRANSACTION_ACTION_ID IN (1, 27 )
6478: AND PROCESS_FLAG = 1
6479: AND EXISTS (
6480: SELECT NULL
6481: FROM MTL_TRANSACTION_TYPES MTTY
6482: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
6483: AND MTTY.TYPE_CLASS = 1 )
6484: AND NOT EXISTS (
6485: SELECT NULL