APPS.INV_TXN_MANAGER_GRP dependencies on WIP_ENTITIES

Line 3367: FROM WIP_ENTITIES WEN

3363: AND TRANSACTION_SOURCE_TYPE_ID = 5
3364: AND UPPER(NVL(FLOW_SCHEDULE,'N')) = 'N'
3365: AND NOT EXISTS (
3366: SELECT NULL
3367: FROM WIP_ENTITIES WEN
3368: WHERE WEN.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3369: AND WEN.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID);
3370:
3371: l_count := SQL%ROWCOUNT;

Line 3406: FROM WIP_ENTITIES WEN

3402: AND TRANSACTION_SOURCE_TYPE_ID = 5
3403: AND UPPER(NVL(FLOW_SCHEDULE,'N')) = 'Y'
3404: AND NOT EXISTS (
3405: SELECT NULL
3406: FROM WIP_ENTITIES WEN
3407: WHERE WEN.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3408: AND WEN.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID);
3409:
3410: l_count := SQL%ROWCOUNT;

Line 3840: FROM WIP_ENTITIES WE

3836: INVENTORY_ITEM_ID = (SELECT DECODE(MTI.TRANSACTION_ACTION_ID,30,
3837: PRIMARY_ITEM_ID,31,PRIMARY_ITEM_ID,32,
3838: PRIMARY_ITEM_ID,
3839: MTI.INVENTORY_ITEM_ID) -- CFM Scrap Transactions
3840: FROM WIP_ENTITIES WE
3841: WHERE WE.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID
3842: AND WE.ORGANIZATION_ID = MTI.ORGANIZATION_ID),
3843: WIP_ENTITY_TYPE = (SELECT ENTITY_TYPE
3844: FROM WIP_ENTITIES WE

Line 3844: FROM WIP_ENTITIES WE

3840: FROM WIP_ENTITIES WE
3841: WHERE WE.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID
3842: AND WE.ORGANIZATION_ID = MTI.ORGANIZATION_ID),
3843: WIP_ENTITY_TYPE = (SELECT ENTITY_TYPE
3844: FROM WIP_ENTITIES WE
3845: WHERE WE.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3846: AND WE.WIP_ENTITY_ID = MTI.TRANSACTION_SOURCE_ID)
3847: WHERE TRANSACTION_HEADER_ID = p_header_id
3848: AND TRANSACTION_SOURCE_TYPE_ID = 5