DBA Data[Home] [Help]

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: