DBA Data[Home] [Help]

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on WIP_FLOW_SCHEDULES

Line 173: schedule_number wip_flow_schedules.schedule_number%type,

169: TYPE r_flow_sch_details IS RECORD(
170: t_flow_sch_index number,
171: order_line_id number, --sales order_line_id
172: t_item_details_index number,
173: schedule_number wip_flow_schedules.schedule_number%type,
174: wip_entity_id wip_flow_schedules.wip_entity_id%type,
175: scheduled_start_date wip_flow_schedules.scheduled_start_date%type,
176: planned_quantity wip_flow_schedules.planned_quantity%type,
177: scheduled_completion_date wip_flow_schedules.scheduled_completion_date%type,

Line 174: wip_entity_id wip_flow_schedules.wip_entity_id%type,

170: t_flow_sch_index number,
171: order_line_id number, --sales order_line_id
172: t_item_details_index number,
173: schedule_number wip_flow_schedules.schedule_number%type,
174: wip_entity_id wip_flow_schedules.wip_entity_id%type,
175: scheduled_start_date wip_flow_schedules.scheduled_start_date%type,
176: planned_quantity wip_flow_schedules.planned_quantity%type,
177: scheduled_completion_date wip_flow_schedules.scheduled_completion_date%type,
178: build_sequence wip_flow_schedules.build_sequence%type,

Line 175: scheduled_start_date wip_flow_schedules.scheduled_start_date%type,

171: order_line_id number, --sales order_line_id
172: t_item_details_index number,
173: schedule_number wip_flow_schedules.schedule_number%type,
174: wip_entity_id wip_flow_schedules.wip_entity_id%type,
175: scheduled_start_date wip_flow_schedules.scheduled_start_date%type,
176: planned_quantity wip_flow_schedules.planned_quantity%type,
177: scheduled_completion_date wip_flow_schedules.scheduled_completion_date%type,
178: build_sequence wip_flow_schedules.build_sequence%type,
179: line_id wip_flow_schedules.line_id%type,

Line 176: planned_quantity wip_flow_schedules.planned_quantity%type,

172: t_item_details_index number,
173: schedule_number wip_flow_schedules.schedule_number%type,
174: wip_entity_id wip_flow_schedules.wip_entity_id%type,
175: scheduled_start_date wip_flow_schedules.scheduled_start_date%type,
176: planned_quantity wip_flow_schedules.planned_quantity%type,
177: scheduled_completion_date wip_flow_schedules.scheduled_completion_date%type,
178: build_sequence wip_flow_schedules.build_sequence%type,
179: line_id wip_flow_schedules.line_id%type,
180: line_code wip_lines.line_code%type,

Line 177: scheduled_completion_date wip_flow_schedules.scheduled_completion_date%type,

173: schedule_number wip_flow_schedules.schedule_number%type,
174: wip_entity_id wip_flow_schedules.wip_entity_id%type,
175: scheduled_start_date wip_flow_schedules.scheduled_start_date%type,
176: planned_quantity wip_flow_schedules.planned_quantity%type,
177: scheduled_completion_date wip_flow_schedules.scheduled_completion_date%type,
178: build_sequence wip_flow_schedules.build_sequence%type,
179: line_id wip_flow_schedules.line_id%type,
180: line_code wip_lines.line_code%type,
181: synch_schedule_num wip_flow_schedules.synch_schedule_num%type,

Line 178: build_sequence wip_flow_schedules.build_sequence%type,

174: wip_entity_id wip_flow_schedules.wip_entity_id%type,
175: scheduled_start_date wip_flow_schedules.scheduled_start_date%type,
176: planned_quantity wip_flow_schedules.planned_quantity%type,
177: scheduled_completion_date wip_flow_schedules.scheduled_completion_date%type,
178: build_sequence wip_flow_schedules.build_sequence%type,
179: line_id wip_flow_schedules.line_id%type,
180: line_code wip_lines.line_code%type,
181: synch_schedule_num wip_flow_schedules.synch_schedule_num%type,
182: SYNCH_OPERATION_SEQ_NUM wip_flow_schedules.SYNCH_OPERATION_SEQ_NUM%type

Line 179: line_id wip_flow_schedules.line_id%type,

175: scheduled_start_date wip_flow_schedules.scheduled_start_date%type,
176: planned_quantity wip_flow_schedules.planned_quantity%type,
177: scheduled_completion_date wip_flow_schedules.scheduled_completion_date%type,
178: build_sequence wip_flow_schedules.build_sequence%type,
179: line_id wip_flow_schedules.line_id%type,
180: line_code wip_lines.line_code%type,
181: synch_schedule_num wip_flow_schedules.synch_schedule_num%type,
182: SYNCH_OPERATION_SEQ_NUM wip_flow_schedules.SYNCH_OPERATION_SEQ_NUM%type
183:

Line 181: synch_schedule_num wip_flow_schedules.synch_schedule_num%type,

177: scheduled_completion_date wip_flow_schedules.scheduled_completion_date%type,
178: build_sequence wip_flow_schedules.build_sequence%type,
179: line_id wip_flow_schedules.line_id%type,
180: line_code wip_lines.line_code%type,
181: synch_schedule_num wip_flow_schedules.synch_schedule_num%type,
182: SYNCH_OPERATION_SEQ_NUM wip_flow_schedules.SYNCH_OPERATION_SEQ_NUM%type
183:
184: );
185:

Line 182: SYNCH_OPERATION_SEQ_NUM wip_flow_schedules.SYNCH_OPERATION_SEQ_NUM%type

178: build_sequence wip_flow_schedules.build_sequence%type,
179: line_id wip_flow_schedules.line_id%type,
180: line_code wip_lines.line_code%type,
181: synch_schedule_num wip_flow_schedules.synch_schedule_num%type,
182: SYNCH_OPERATION_SEQ_NUM wip_flow_schedules.SYNCH_OPERATION_SEQ_NUM%type
183:
184: );
185:
186:

Line 2093: FROM wip_flow_schedules wfs,

2089: wfs.scheduled_completion_date,
2090: wfs.build_sequence,
2091: wfs.line_id,
2092: wil.line_code
2093: FROM wip_flow_schedules wfs,
2094: wip_lines wil
2095: WHERE demand_source_line = p_Top_Assembly_LineId
2096: AND wfs.line_id = wil.line_id;
2097:

Line 2257: FROM wip_flow_schedules

2253: build_sequence,
2254: line_id,
2255: synch_schedule_num,
2256: SYNCH_OPERATION_SEQ_NUM
2257: FROM wip_flow_schedules
2258: where demand_source_line = p_Top_Assembly_LineId;
2259:
2260: END IF;
2261:

Line 2854: FROM wip_flow_schedules

2850: build_sequence,
2851: line_id,
2852: synch_schedule_num,
2853: SYNCH_OPERATION_SEQ_NUM
2854: FROM wip_flow_schedules
2855: where primary_item_id = l_mlsupply_items(l_index).item_id
2856: and synch_schedule_num in
2857: ( Select schedule_number
2858: from BOM_CTO_MLSUPPLY_FLOW_TEMP