APPS.WIP_MTI_PUB dependencies on WIP_FLOW_SCHEDULES

Line 661: from wip_flow_schedules

657: if ( upper(pt_rec.flow_schedule) = 'Y' ) then
658: if ( pt_rec.scheduled_flag = 1 ) then
659: select project_id, task_id
660: into l_projID, l_taskID
661: from wip_flow_schedules
662: where wip_entity_id = pt_rec.transaction_source_id;
663: else
664: l_projID := pt_rec.source_project_id;
665: l_taskID := pt_rec.source_task_id;

Line 907: from wip_flow_schedules wfs

903: and wdj.organization_id = mti.organization_id
904: and wdj.primary_item_id is null))
905: or ( upper(nvl(mti.flow_schedule, 'N')) = 'Y'
906: and exists (select 'X'
907: from wip_flow_schedules wfs
908: where wfs.wip_entity_id = mti.transaction_source_id
909: and wfs.organization_id = mti.organization_id
910: and primary_item_id is null)));
911:

Line 1211: from wip_flow_schedules wfs

1207: program_id = fnd_global.conc_program_id,
1208: program_update_date = sysdate,
1209: request_id = fnd_global.conc_request_id,
1210: revision = (select nvl(mti.revision, wfs.bom_revision)
1211: from wip_flow_schedules wfs
1212: where wfs.organization_id = mti.organization_id
1213: and wfs.wip_entity_id = mti.transaction_source_id)
1214: where transaction_header_id = p_txnHeaderID
1215: and transaction_source_type_id = 5

Line 2544: from wip_flow_schedules

2540: request_id = fnd_global.conc_request_id,
2541: (source_project_id, source_task_id) =
2542: (select project_id,
2543: task_id
2544: from wip_flow_schedules
2545: where wip_entity_id = mti.transaction_source_id
2546: and organization_id = mti.organization_id)
2547: where transaction_header_id = p_txnHeaderID
2548: and process_flag = 1

Line 2602: from wip_flow_schedules wfs

2598: and transaction_source_id is not null
2599: and transaction_action_id in (WIP_CONSTANTS.SCRASSY_ACTION,
2600: WIP_CONSTANTS.CPLASSY_ACTION)
2601: and exists (select 1
2602: from wip_flow_schedules wfs
2603: where wfs.organization_id = mti.organization_id
2604: and wfs.wip_entity_id = mti.transaction_source_id
2605: and wfs.status = 2);
2606: