APPS.INV_TXN_MANAGER_GRP dependencies on MTL_TRANSACTION_TYPES

Line 1556: FROM mtl_transaction_types

1552: l_is_reversal NUMBER := 0;
1553: CURSOR get_transaction_details( trx_type_id IN NUMBER) IS
1554: SELECT transaction_action_id
1555: , transaction_source_type_id
1556: FROM mtl_transaction_types
1557: WHERE transaction_type_id = trx_type_id;
1558: l_transaction_action_id NUMBER;
1559: l_transaction_source_type_id NUMBER;
1560: x_primary_quantity NUMBER; /* Fix for Bug#11729772*/

Line 1987: FROM MTL_TRANSACTION_TYPES MTT

1983: LAST_UPDATE_LOGIN = p_loginid,
1984: PROGRAM_UPDATE_DATE = SYSDATE,
1985: TRANSACTION_ACTION_ID =
1986: (SELECT MTT.TRANSACTION_ACTION_ID
1987: FROM MTL_TRANSACTION_TYPES MTT
1988: WHERE MTT.TRANSACTION_TYPE_ID
1989: = MTI.TRANSACTION_TYPE_ID),
1990: TRANSACTION_SOURCE_TYPE_ID =
1991: (SELECT MTT.TRANSACTION_SOURCE_TYPE_ID

Line 1992: FROM MTL_TRANSACTION_TYPES MTT

1988: WHERE MTT.TRANSACTION_TYPE_ID
1989: = MTI.TRANSACTION_TYPE_ID),
1990: TRANSACTION_SOURCE_TYPE_ID =
1991: (SELECT MTT.TRANSACTION_SOURCE_TYPE_ID
1992: FROM MTL_TRANSACTION_TYPES MTT
1993: WHERE MTT.TRANSACTION_TYPE_ID
1994: = MTI.TRANSACTION_TYPE_ID)
1995: WHERE TRANSACTION_HEADER_ID = p_header_id
1996: AND PROCESS_FLAG = 1;

Line 2885: FROM MTL_TRANSACTION_TYPES MTT

2881: WHERE TRANSACTION_HEADER_ID = p_header_id
2882: AND PROCESS_FLAG = 1
2883: AND NOT EXISTS (
2884: SELECT NULL
2885: FROM MTL_TRANSACTION_TYPES MTT
2886: WHERE MTT.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
2887: AND nvl(MTT.DISABLE_DATE,SYSDATE+1) > SYSDATE );
2888:
2889: l_count := SQL%ROWCOUNT;

Line 3657: FROM MTL_TRANSACTION_TYPES MTTY

3653: AND TRANSACTION_ACTION_ID IN (1, 27 )
3654: AND PROCESS_FLAG = 1
3655: AND EXISTS (
3656: SELECT NULL
3657: FROM MTL_TRANSACTION_TYPES MTTY
3658: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
3659: AND MTTY.TYPE_CLASS = 1 )
3660: AND NOT EXISTS (
3661: SELECT NULL

Line 3712: FROM MTL_TRANSACTION_TYPES MTTY

3708: AND TRANSACTION_ACTION_ID IN (1, 27 )
3709: AND PROCESS_FLAG = 1
3710: AND EXISTS (
3711: SELECT NULL
3712: FROM MTL_TRANSACTION_TYPES MTTY
3713: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
3714: AND MTTY.TYPE_CLASS = 1 )
3715: AND NOT EXISTS (
3716: SELECT NULL

Line 3746: FROM MTL_TRANSACTION_TYPES MTTY

3742: AND TRANSACTION_ACTION_ID IN (1, 27 )
3743: AND PROCESS_FLAG = 1
3744: AND EXISTS (
3745: SELECT NULL
3746: FROM MTL_TRANSACTION_TYPES MTTY
3747: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
3748: AND MTTY.TYPE_CLASS = 1 )
3749: AND MTI.EXPENDITURE_TYPE IS NOT NULL ;
3750:

Line 6844: FROM MTL_TRANSACTION_TYPES MTTY

6840: AND TRANSACTION_ACTION_ID IN (1, 27 )
6841: AND PROCESS_FLAG = 1
6842: AND EXISTS (
6843: SELECT null
6844: FROM MTL_TRANSACTION_TYPES MTTY
6845: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
6846: AND MTTY.TYPE_CLASS = 1 )
6847: AND NOT EXISTS (
6848: SELECT null

Line 6952: FROM MTL_TRANSACTION_TYPES MTTY

6948: AND TRANSACTION_ACTION_ID IN (1, 27 )
6949: AND PROCESS_FLAG = 1
6950: AND EXISTS (
6951: SELECT NULL
6952: FROM MTL_TRANSACTION_TYPES MTTY
6953: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
6954: AND MTTY.TYPE_CLASS = 1 )
6955: AND NOT EXISTS (
6956: SELECT NULL