APPS.INV_TXN_MANAGER_GRP dependencies on WIP_ENTITIES

Line 3554: FROM WIP_ENTITIES WEN

3550: AND TRANSACTION_SOURCE_TYPE_ID = 5
3551: AND UPPER(NVL(FLOW_SCHEDULE,'N')) = 'N'
3552: AND NOT EXISTS (
3553: SELECT NULL
3554: FROM WIP_ENTITIES WEN
3555: WHERE WEN.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3556: AND WEN.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID);
3557:
3558: l_count := SQL%ROWCOUNT;

Line 3593: FROM WIP_ENTITIES WEN

3589: AND TRANSACTION_SOURCE_TYPE_ID = 5
3590: AND UPPER(NVL(FLOW_SCHEDULE,'N')) = 'Y'
3591: AND NOT EXISTS (
3592: SELECT NULL
3593: FROM WIP_ENTITIES WEN
3594: WHERE WEN.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3595: AND WEN.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID);
3596:
3597: l_count := SQL%ROWCOUNT;

Line 4119: FROM WIP_ENTITIES WE

4115: INVENTORY_ITEM_ID = (SELECT DECODE(MTI.TRANSACTION_ACTION_ID,30,
4116: PRIMARY_ITEM_ID,31,PRIMARY_ITEM_ID,32,
4117: PRIMARY_ITEM_ID,
4118: MTI.INVENTORY_ITEM_ID) -- CFM Scrap Transactions
4119: FROM WIP_ENTITIES WE
4120: WHERE WE.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID
4121: AND WE.ORGANIZATION_ID = MTI.ORGANIZATION_ID),
4122: WIP_ENTITY_TYPE = (SELECT ENTITY_TYPE
4123: FROM WIP_ENTITIES WE

Line 4123: FROM WIP_ENTITIES WE

4119: FROM WIP_ENTITIES WE
4120: WHERE WE.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID
4121: AND WE.ORGANIZATION_ID = MTI.ORGANIZATION_ID),
4122: WIP_ENTITY_TYPE = (SELECT ENTITY_TYPE
4123: FROM WIP_ENTITIES WE
4124: WHERE WE.ORGANIZATION_ID = MTI.ORGANIZATION_ID
4125: AND WE.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID)
4126: WHERE TRANSACTION_HEADER_ID = p_header_id
4127: AND TRANSACTION_SOURCE_TYPE_ID = 5