APPS.WIP_MTI_PUB dependencies on WIP_REPETITIVE_SCHEDULES

Line 870: from wip_repetitive_schedules wrs

866: and wdj.organization_id = mti.organization_id
867: and wdj.status_type in (3,4)))
868: or ( mti.wip_entity_type = 2
869: and not exists (select 'X'
870: from wip_repetitive_schedules wrs
871: where wrs.wip_entity_id = mti.transaction_source_id
872: and wrs.organization_id = mti.organization_id
873: and wrs.line_id = mti.repetitive_line_id
874: and wrs.status_type in (3,4)))

Line 922: from wip_repetitive_schedules wrs1

918: program_id = fnd_global.conc_program_id,
919: program_update_date = sysdate,
920: request_id = fnd_global.conc_request_id,
921: schedule_id = (select repetitive_schedule_id
922: from wip_repetitive_schedules wrs1
923: where wrs1.organization_id = mti.organization_id
924: and wrs1.wip_entity_id = mti.transaction_source_id
925: and wrs1.line_id = mti.repetitive_line_id
926: and wrs1.status_type in (3, 4)

Line 929: from wip_repetitive_schedules wrs2

925: and wrs1.line_id = mti.repetitive_line_id
926: and wrs1.status_type in (3, 4)
927: and wrs1.first_unit_start_date =
928: (select min(wrs2.first_unit_start_date)
929: from wip_repetitive_schedules wrs2
930: where wrs2.organization_id = mti.organization_id
931: and wrs2.wip_entity_id = mti.transaction_source_id
932: and wrs2.line_id = mti.repetitive_line_id
933: and wrs2.status_type in (3,4)))

Line 1079: wip_repetitive_schedules wrs

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

Line 1186: from wip_repetitive_schedules wrs

1182: program_id = fnd_global.conc_program_id,
1183: program_update_date = sysdate,
1184: request_id = fnd_global.conc_request_id,
1185: revision = (select nvl(mti.revision, wrs.bom_revision)
1186: from wip_repetitive_schedules wrs
1187: where wrs.organization_id = mti.organization_id
1188: and wrs.repetitive_schedule_id = mti.schedule_id)
1189: where transaction_header_id = p_txnHeaderID
1190: and transaction_source_type_id = 5

Line 1439: from wip_repetitive_schedules

1435: and ( mti.wip_entity_type in (1,5)
1436: or ( mti.wip_entity_type = 2
1437: and wo.repetitive_schedule_id in
1438: (select repetitive_schedule_id
1439: from wip_repetitive_schedules
1440: where wip_entity_id = mti.transaction_source_id
1441: and organization_id = mti.organization_id
1442: and line_id = mti.repetitive_line_id
1443: and status_type in (3,4)))));

Line 1545: from wip_repetitive_schedules wrs

1541: and transaction_source_type_id = 5
1542: and ( ( mti.wip_entity_type = 2
1543: and mti.transaction_date <
1544: (select min(wrs.date_released)
1545: from wip_repetitive_schedules wrs
1546: where wrs.line_id = mti.repetitive_line_id
1547: and wrs.organization_id = mti.organization_id
1548: and wrs.wip_entity_id = mti.transaction_source_id
1549: and wrs.status_type in (3,4)))