DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1071: from wip_requirement_operations wro

1067: msi.eng_item_flag,
1068: 'N'))
1069: and ( ( mti.wip_entity_type in (1,5)
1070: and not exists(select 'X'
1071: from wip_requirement_operations wro
1072: where wro.organization_id = mti.organization_id
1073: and wro.wip_entity_id = mti.transaction_source_id
1074: and wro.inventory_item_id = mti.inventory_item_id
1075: and wro.operation_seq_num = mti.operation_seq_num))

Line 1078: from wip_requirement_operations wro,

1074: and wro.inventory_item_id = mti.inventory_item_id
1075: and wro.operation_seq_num = mti.operation_seq_num))
1076: or ( mti.wip_entity_type = 2
1077: and not exists(select 'X'
1078: from wip_requirement_operations wro,
1079: wip_repetitive_schedules wrs
1080: where wro.organization_id = mti.organization_id
1081: and wro.wip_entity_id = mti.transaction_source_id
1082: and wro.inventory_item_id = mti.inventory_item_id