APPS.WIP_PENDING_TXNS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP
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: