APPS.FLM_EXECUTION_UTIL dependencies on WIP_FLOW_SCHEDULES

Line 342: wip_flow_schedules wfs,

338:
339: BEGIN
340: select bos.operation_sequence_id into l_op_seq_id
341: from bom_operation_sequences bos,
342: wip_flow_schedules wfs,
343: bom_operational_routings bor
344: where wfs.wip_entity_id = i_wip_entity_id
345: and bor.organization_id = i_org_id
346: and bor.assembly_item_id = wfs.primary_item_id

Line 441: wip_flow_schedules wfs,

437: -- standard operation.
438: CURSOR op_seq_csr IS
439: select bos.operation_sequence_id
440: from bom_operation_sequences bos,
441: wip_flow_schedules wfs,
442: bom_operational_routings bor
443: where wfs.wip_entity_id = i_wip_entity_id
444: and bor.organization_id = i_org_id
445: and bor.assembly_item_id = wfs.primary_item_id

Line 455: wip_flow_schedules wfs,

451: CURSOR start_op_csr IS
452: select bos.operation_sequence_id seq_id,
453: bos.operation_seq_num seq_num
454: from bom_operation_sequences bos,
455: wip_flow_schedules wfs,
456: bom_operational_routings bor
457: where wfs.wip_entity_id = i_wip_entity_id
458: and bor.organization_id = i_org_id
459: and bor.assembly_item_id = wfs.primary_item_id

Line 484: from wip_flow_schedules wfs

480: BEGIN
481:
482: --wip_logger.log('Start: Operation_Eligible i_org_id: ' || i_org_id || ' i_wip_entity_id: ' || i_wip_entity_id || ' i_std_op_id: ' || i_std_op_id, l_retStatus);
483: select line_id into l_line_id
484: from wip_flow_schedules wfs
485: where wfs.wip_entity_id = i_wip_entity_id
486: and wfs.organization_id = i_org_id;
487:
488: --Bug 13812197: Initializing/Clearing cache

Line 1819: from wip_flow_schedules

1815: BEGIN
1816:
1817: select wip_entity_id
1818: into l_wip_ent_id
1819: from wip_flow_schedules
1820: where organization_id = orgId
1821: and schedule_number = schNum;
1822:
1823: return (scheduleRecordedDetailsExist(orgId, l_wip_ent_id));

Line 2159: wip_flow_schedules wfs

2155: CURSOR bill_seq IS
2156: select bbom.bill_sequence_id,
2157: wfs.bom_revision_date
2158: from bom_bill_of_materials bbom,
2159: wip_flow_schedules wfs
2160: where wfs.wip_entity_id = p_wip_entity_id
2161: and wfs.organization_id = p_org_id
2162: and bbom.assembly_item_id = wfs.primary_item_id
2163: and bbom.organization_id = wfs.organization_id

Line 2230: wip_flow_schedules wfs,

2226: select bos.operation_sequence_id, bor.common_routing_sequence_id,
2227: nvl(wfs.routing_revision_date, wfs.scheduled_completion_date)
2228: as routing_revision_date
2229: from bom_operation_sequences bos,
2230: wip_flow_schedules wfs,
2231: bom_operational_routings bor
2232: where wfs.wip_entity_id = p_wip_entity_id
2233: and wfs.organization_id = p_org_id
2234: and bor.organization_id = p_org_id