APPS.WIP_MTI_PUB dependencies on WIP_OPERATIONS

Line 973: from wip_operations wo

969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
971: request_id = fnd_global.conc_request_id,
972: operation_seq_num = (select max(operation_seq_num)
973: from wip_operations wo
974: where wo.organization_id = mti.organization_id
975: and wo.wip_entity_id = mti.transaction_source_id
976: and ( mti.wip_entity_type in (1,5)
977: or ( mti.wip_entity_type = 2

Line 996: from wip_operations wo

992: program_id = fnd_global.conc_program_id,
993: program_update_date = sysdate,
994: request_id = fnd_global.conc_request_id,
995: operation_seq_num = (select nvl(max(operation_seq_num), 1)
996: from wip_operations wo
997: where wo.organization_id = mti.organization_id
998: and wo.wip_entity_id = mti.transaction_source_id
999: and ( mti.wip_entity_type in (1,5,6)
1000: or ( mti.wip_entity_type = 2

Line 1039: from wip_operations wo

1035: and 0 =(select decode(count(wo.operation_seq_num),
1036: 0,
1037: decode(mti.operation_seq_num, 1, 1, 0),
1038: decode(sum(decode(sign(mti.operation_seq_num-wo.operation_seq_num),0,1,0)),0,0,1))
1039: from wip_operations wo
1040: where wo.wip_entity_id = mti.transaction_source_id
1041: and wo.organization_id = mti.organization_id
1042: and ((mti.wip_entity_type in (1, 5, 6) and (mti.wip_entity_type <> 5 or (mti.wip_entity_type = 5 and nvl(wo.disable_date,mti.transaction_date+1) > mti.transaction_date)))
1043: or ( mti.wip_entity_type = 2 and wo.repetitive_schedule_id = mti.schedule_id)));

Line 1477: from wip_operations wo

1473: and wip_entity_type <> 4
1474: and operation_seq_num is not null
1475: and (primary_quantity - nvl(overcompletion_primary_qty, 0)) >
1476: (select sum(quantity_waiting_to_move)
1477: from wip_operations wo
1478: where wo.wip_entity_id = mti.transaction_source_id
1479: and wo.organization_id = mti.organization_id
1480: and wo.operation_seq_num = mti.operation_seq_num
1481: and ( mti.wip_entity_type in (1,5)