APPS.WIP_MTI_PUB dependencies on WIP_ENTITIES

Line 96: wip_entities we,

92: mti.task_id,
93: mti.reason_id,
94: mti.transaction_reference
95: from mtl_transactions_interface mti,
96: wip_entities we,
97: mtl_system_items msi
98: where mti.transaction_header_id = p_txnHeaderID
99: and mti.transaction_source_type_id = 5
100: and mti.transaction_action_id in (wip_constants.cplassy_action,

Line 1906: wip_entities we

1902: and transaction_source_id is not null
1903: and not exists
1904: (select 'x'
1905: from wip_discrete_jobs wdj,
1906: wip_entities we
1907: where wdj.wip_entity_id = mti.transaction_source_id
1908: and wdj.organization_id = mti.organization_id
1909: and wdj.wip_entity_id = we.wip_entity_id
1910: and (we.entity_type = wip_constants.lotbased or

Line 2234: from wip_entities we

2230: and transaction_source_type_id = 5
2231: and transaction_source_id is null
2232: and transaction_source_name is not null
2233: and not exists (select 'X'
2234: from wip_entities we
2235: where we.organization_id = mti.organization_id
2236: and we.wip_entity_name = mti.transaction_source_name);
2237:
2238:

Line 2249: from wip_entities we

2245: program_id = fnd_global.conc_program_id,
2246: program_update_date = sysdate,
2247: request_id = fnd_global.conc_request_id,
2248: transaction_source_id = (select we.wip_entity_id
2249: from wip_entities we
2250: where we.organization_id = mti.organization_id
2251: and we.wip_entity_name = mti.transaction_source_name)
2252: where transaction_header_id = p_txnHeaderID
2253: and process_flag = 1

Line 2305: from wip_entities we

2301: and process_flag = 1
2302: and transaction_source_type_id = 5
2303: and ( (upper(nvl(flow_schedule, 'N')) = 'N'
2304: and not exists (select null
2305: from wip_entities we
2306: where we.organization_id = mti.organization_id
2307: and we.wip_entity_id = mti.transaction_source_id))
2308: or (upper(nvl(flow_schedule, 'N')) = 'Y'
2309: and scheduled_flag = 1

Line 2311: from wip_entities we

2307: and we.wip_entity_id = mti.transaction_source_id))
2308: or (upper(nvl(flow_schedule, 'N')) = 'Y'
2309: and scheduled_flag = 1
2310: and not exists (select null
2311: from wip_entities we
2312: where we.organization_id = mti.organization_id
2313: and we.wip_entity_id = mti.transaction_source_id
2314: and we.entity_type = 4)));
2315:

Line 2394: from wip_entities we

2390: program_id = fnd_global.conc_program_id,
2391: program_update_date = sysdate,
2392: request_id = fnd_global.conc_request_id,
2393: inventory_item_id = (select primary_item_id
2394: from wip_entities we
2395: where we.organization_id = mti.organization_id
2396: and we.wip_entity_id = mti.transaction_source_id)
2397: where transaction_header_id = p_txnHeaderID
2398: and transaction_source_type_id = 5

Line 2551: from wip_entities we

2547: program_id = fnd_global.conc_program_id,
2548: program_update_date = sysdate,
2549: request_id = fnd_global.conc_request_id,
2550: wip_entity_type = (select entity_type
2551: from wip_entities we
2552: where we.organization_id = mti.organization_id
2553: and we.wip_entity_id = mti.transaction_source_id)
2554: where transaction_header_id = p_txnHeaderID
2555: and transaction_source_type_id = 5