APPS.WSM_WSMPNTXN_XMLP_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 40: MTL_MATERIAL_TRANSACTIONS_TEMP

36: UNION ALL
37: SELECT
38: TRANSACTION_SOURCE_ID
39: FROM
40: MTL_MATERIAL_TRANSACTIONS_TEMP
41: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
42: AND TRANSACTION_SOURCE_TYPE_ID = 5
43: UNION ALL
44: SELECT

Line 47: MTL_MATERIAL_TRANSACTIONS

43: UNION ALL
44: SELECT
45: TRANSACTION_SOURCE_ID
46: FROM
47: MTL_MATERIAL_TRANSACTIONS
48: WHERE COSTED_FLAG in ( 'N' , 'E' )
49: AND TRANSACTION_SOURCE_TYPE_ID = 5
50: AND ORGANIZATION_ID = P_ORGANIZATION_ID
51: UNION ALL

Line 186: MTL_MATERIAL_TRANSACTIONS_TEMP

182: WHERE exists (
183: SELECT
184: 1
185: FROM
186: MTL_MATERIAL_TRANSACTIONS_TEMP
187: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
188: AND TRANSACTION_SOURCE_ID = WIP_ENTITY_ID_1
189: AND TRANSACTION_SOURCE_TYPE_ID = 5 );
190: EXCEPTION

Line 211: MTL_MATERIAL_TRANSACTIONS

207: WHERE exists (
208: SELECT
209: 1
210: FROM
211: MTL_MATERIAL_TRANSACTIONS
212: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
213: AND TRANSACTION_SOURCE_ID = WIP_ENTITY_ID_1
214: AND COSTED_FLAG IN ( 'N' , 'E' )
215: AND TRANSACTION_SOURCE_TYPE_ID = 5 );