APPS.WIP_UNRELEASE dependencies on MTL_MATERIAL_TRANSACTIONS

Line 55: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

51: FROM WIP_COST_TXN_INTERFACE
52: WHERE ORGANIZATION_ID = x_org_id
53: AND WIP_ENTITY_ID = x_wip_id)
54: OR EXISTS (SELECT 'X'
55: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
56: WHERE ORGANIZATION_ID = x_org_id
57: AND TRANSACTION_SOURCE_TYPE_ID = 5
58: AND TRANSACTION_SOURCE_ID = x_wip_id)
59: OR EXISTS (SELECT 'X'

Line 65: FROM MTL_MATERIAL_TRANSACTIONS

61: WHERE ORGANIZATION_ID = x_org_id
62: AND WIP_ENTITY_ID = x_wip_id
63: AND APPLIED_RESOURCE_UNITS <> 0)
64: OR EXISTS (SELECT 'X' /*Bug 5462655 - Added to check uncosted/erred out transactions in MMT. */
65: FROM MTL_MATERIAL_TRANSACTIONS
66: WHERE ORGANIZATION_ID = x_org_id
67: AND TRANSACTION_SOURCE_TYPE_ID = 5
68: AND TRANSACTION_SOURCE_ID = x_wip_id
69: AND COSTED_FLAG IN ('N', 'E'))

Line 133: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

129: AND WIP_ENTITY_ID = x_wip_id
130: AND LINE_ID = x_line_id)
131: OR EXISTS
132: (SELECT 'X'
133: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
134: WHERE ORGANIZATION_ID = x_org_id
135: AND TRANSACTION_SOURCE_ID = x_wip_id
136: AND TRANSACTION_SOURCE_TYPE_ID = 5
137: AND REPETITIVE_LINE_ID = x_line_id)