APPS.WIP_MTI_PUB dependencies on WIP_FLOW_SCHEDULES

Line 676: from wip_flow_schedules

672: if ( upper(pt_rec.flow_schedule) = 'Y' ) then
673: if ( pt_rec.scheduled_flag = 1 ) then
674: select project_id, task_id
675: into l_projID, l_taskID
676: from wip_flow_schedules
677: where wip_entity_id = pt_rec.transaction_source_id;
678: else
679: l_projID := pt_rec.source_project_id;
680: l_taskID := pt_rec.source_task_id;

Line 930: from wip_flow_schedules wfs

926: and wdj.organization_id = mti.organization_id
927: and wdj.primary_item_id is null))
928: or ( upper(nvl(mti.flow_schedule, 'N')) = 'Y'
929: and exists (select 'X'
930: from wip_flow_schedules wfs
931: where wfs.wip_entity_id = mti.transaction_source_id
932: and wfs.organization_id = mti.organization_id
933: and primary_item_id is null)));
934:

Line 1257: from wip_flow_schedules wfs

1253: program_id = fnd_global.conc_program_id,
1254: program_update_date = sysdate,
1255: request_id = fnd_global.conc_request_id,
1256: revision = (select nvl(mti.revision, wfs.bom_revision)
1257: from wip_flow_schedules wfs
1258: where wfs.organization_id = mti.organization_id
1259: and wfs.wip_entity_id = mti.transaction_source_id)
1260: where transaction_header_id = p_txnHeaderID
1261: and transaction_source_type_id = 5

Line 2593: from wip_flow_schedules

2589: request_id = fnd_global.conc_request_id,
2590: (source_project_id, source_task_id) =
2591: (select project_id,
2592: task_id
2593: from wip_flow_schedules
2594: where wip_entity_id = mti.transaction_source_id
2595: and organization_id = mti.organization_id)
2596: where transaction_header_id = p_txnHeaderID
2597: and process_flag = 1

Line 2651: from wip_flow_schedules wfs

2647: and transaction_source_id is not null
2648: and transaction_action_id in (WIP_CONSTANTS.SCRASSY_ACTION,
2649: WIP_CONSTANTS.CPLASSY_ACTION)
2650: and exists (select 1
2651: from wip_flow_schedules wfs
2652: where wfs.organization_id = mti.organization_id
2653: and wfs.wip_entity_id = mti.transaction_source_id
2654: and wfs.status = 2);
2655: