APPS.WIP_MTI_PUB dependencies on WIP_ENTITIES

Line 89: wip_entities we,

85: mti.task_id,
86: mti.reason_id,
87: mti.transaction_reference
88: from mtl_transactions_interface mti,
89: wip_entities we,
90: mtl_system_items msi
91: where mti.transaction_header_id = p_txnHeaderID
92: and mti.transaction_source_type_id = 5
93: and mti.transaction_action_id in (wip_constants.cplassy_action,

Line 1860: wip_entities we

1856: and transaction_source_id is not null
1857: and not exists
1858: (select 'x'
1859: from wip_discrete_jobs wdj,
1860: wip_entities we
1861: where wdj.wip_entity_id = mti.transaction_source_id
1862: and wdj.organization_id = mti.organization_id
1863: and wdj.wip_entity_id = we.wip_entity_id
1864: and (we.entity_type = wip_constants.lotbased or

Line 2185: from wip_entities we

2181: and transaction_source_type_id = 5
2182: and transaction_source_id is null
2183: and transaction_source_name is not null
2184: and not exists (select 'X'
2185: from wip_entities we
2186: where we.organization_id = mti.organization_id
2187: and we.wip_entity_name = mti.transaction_source_name);
2188:
2189:

Line 2200: from wip_entities we

2196: program_id = fnd_global.conc_program_id,
2197: program_update_date = sysdate,
2198: request_id = fnd_global.conc_request_id,
2199: transaction_source_id = (select we.wip_entity_id
2200: from wip_entities we
2201: where we.organization_id = mti.organization_id
2202: and we.wip_entity_name = mti.transaction_source_name)
2203: where transaction_header_id = p_txnHeaderID
2204: and process_flag = 1

Line 2256: from wip_entities we

2252: and process_flag = 1
2253: and transaction_source_type_id = 5
2254: and ( (upper(nvl(flow_schedule, 'N')) = 'N'
2255: and not exists (select null
2256: from wip_entities we
2257: where we.organization_id = mti.organization_id
2258: and we.wip_entity_id = mti.transaction_source_id))
2259: or (upper(nvl(flow_schedule, 'N')) = 'Y'
2260: and scheduled_flag = 1

Line 2262: from wip_entities we

2258: and we.wip_entity_id = mti.transaction_source_id))
2259: or (upper(nvl(flow_schedule, 'N')) = 'Y'
2260: and scheduled_flag = 1
2261: and not exists (select null
2262: from wip_entities we
2263: where we.organization_id = mti.organization_id
2264: and we.wip_entity_id = mti.transaction_source_id
2265: and we.entity_type = 4)));
2266:

Line 2345: from wip_entities we

2341: program_id = fnd_global.conc_program_id,
2342: program_update_date = sysdate,
2343: request_id = fnd_global.conc_request_id,
2344: inventory_item_id = (select primary_item_id
2345: from wip_entities we
2346: where we.organization_id = mti.organization_id
2347: and we.wip_entity_id = mti.transaction_source_id)
2348: where transaction_header_id = p_txnHeaderID
2349: and transaction_source_type_id = 5

Line 2502: from wip_entities we

2498: program_id = fnd_global.conc_program_id,
2499: program_update_date = sysdate,
2500: request_id = fnd_global.conc_request_id,
2501: wip_entity_type = (select entity_type
2502: from wip_entities we
2503: where we.organization_id = mti.organization_id
2504: and we.wip_entity_id = mti.transaction_source_id)
2505: where transaction_header_id = p_txnHeaderID
2506: and transaction_source_type_id = 5