APPS.WIP_MTI_PUB dependencies on WIP_REPETITIVE_SCHEDULES

Line 893: from wip_repetitive_schedules wrs

889: and wdj.organization_id = mti.organization_id
890: and wdj.status_type in (3,4)))
891: or ( mti.wip_entity_type = 2
892: and not exists (select 'X'
893: from wip_repetitive_schedules wrs
894: where wrs.wip_entity_id = mti.transaction_source_id
895: and wrs.organization_id = mti.organization_id
896: and wrs.line_id = mti.repetitive_line_id
897: and wrs.status_type in (3,4)))

Line 945: from wip_repetitive_schedules wrs1

941: program_id = fnd_global.conc_program_id,
942: program_update_date = sysdate,
943: request_id = fnd_global.conc_request_id,
944: schedule_id = (select repetitive_schedule_id
945: from wip_repetitive_schedules wrs1
946: where wrs1.organization_id = mti.organization_id
947: and wrs1.wip_entity_id = mti.transaction_source_id
948: and wrs1.line_id = mti.repetitive_line_id
949: and wrs1.status_type in (3, 4)

Line 952: from wip_repetitive_schedules wrs2

948: and wrs1.line_id = mti.repetitive_line_id
949: and wrs1.status_type in (3, 4)
950: and wrs1.first_unit_start_date =
951: (select min(wrs2.first_unit_start_date)
952: from wip_repetitive_schedules wrs2
953: where wrs2.organization_id = mti.organization_id
954: and wrs2.wip_entity_id = mti.transaction_source_id
955: and wrs2.line_id = mti.repetitive_line_id
956: and wrs2.status_type in (3,4)))

Line 1094: wip_repetitive_schedules wrs

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
1098: and wro.operation_seq_num = mti.operation_seq_num

Line 1232: from wip_repetitive_schedules wrs

1228: program_id = fnd_global.conc_program_id,
1229: program_update_date = sysdate,
1230: request_id = fnd_global.conc_request_id,
1231: revision = (select nvl(mti.revision, wrs.bom_revision)
1232: from wip_repetitive_schedules wrs
1233: where wrs.organization_id = mti.organization_id
1234: and wrs.repetitive_schedule_id = mti.schedule_id)
1235: where transaction_header_id = p_txnHeaderID
1236: and transaction_source_type_id = 5

Line 1485: from wip_repetitive_schedules

1481: and ( mti.wip_entity_type in (1,5)
1482: or ( mti.wip_entity_type = 2
1483: and wo.repetitive_schedule_id in
1484: (select repetitive_schedule_id
1485: from wip_repetitive_schedules
1486: where wip_entity_id = mti.transaction_source_id
1487: and organization_id = mti.organization_id
1488: and line_id = mti.repetitive_line_id
1489: and status_type in (3,4)))));

Line 1591: from wip_repetitive_schedules wrs

1587: and transaction_source_type_id = 5
1588: and ( ( mti.wip_entity_type = 2
1589: and mti.transaction_date <
1590: (select min(wrs.date_released)
1591: from wip_repetitive_schedules wrs
1592: where wrs.line_id = mti.repetitive_line_id
1593: and wrs.organization_id = mti.organization_id
1594: and wrs.wip_entity_id = mti.transaction_source_id
1595: and wrs.status_type in (3,4)))