APPS.WIP_PENDING_TXNS dependencies on MTL_MATERIAL_TRANSACTIONS

Line 69: -- Check for MTL_MATERIAL_TRANSACTIONS_TEMP

65: EXCEPTION WHEN NO_DATA_FOUND THEN
66: P_MATERIAL_ISSUED := WIP_CONSTANTS.NO;
67: END;
68:
69: -- Check for MTL_MATERIAL_TRANSACTIONS_TEMP
70:
71: BEGIN
72:
73: SELECT WIP_CONSTANTS.YES

Line 77: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

73: SELECT WIP_CONSTANTS.YES
74: INTO P_MTL_TXNS_TEMP
75: FROM DUAL
76: WHERE EXISTS (SELECT 1
77: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
78: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
79: AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
80: AND TRANSACTION_SOURCE_TYPE_ID = 5);
81:

Line 94: FROM MTL_MATERIAL_TRANSACTIONS

90: SELECT WIP_CONSTANTS.YES
91: INTO P_UNCOSTED_MTL_TXNS
92: FROM DUAL
93: WHERE EXISTS (SELECT 1
94: FROM MTL_MATERIAL_TRANSACTIONS
95: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
96: AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
97: AND COSTED_FLAG IN ('N','E')
98: AND TRANSACTION_SOURCE_TYPE_ID = 5);