DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1086: from wip_requirement_operations wro

1082: msi.eng_item_flag,
1083: 'N'))
1084: and ( ( mti.wip_entity_type in (1,5)
1085: and not exists(select 'X'
1086: from wip_requirement_operations wro
1087: where wro.organization_id = mti.organization_id
1088: and wro.wip_entity_id = mti.transaction_source_id
1089: and wro.inventory_item_id = mti.inventory_item_id
1090: and wro.operation_seq_num = mti.operation_seq_num))

Line 1093: from wip_requirement_operations wro,

1089: and wro.inventory_item_id = mti.inventory_item_id
1090: and wro.operation_seq_num = mti.operation_seq_num))
1091: or ( mti.wip_entity_type = 2
1092: and not exists(select 'X'
1093: from wip_requirement_operations wro,
1094: wip_repetitive_schedules wrs
1095: where wro.organization_id = mti.organization_id
1096: and wro.wip_entity_id = mti.transaction_source_id
1097: and wro.inventory_item_id = mti.inventory_item_id