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 2098: FROM wip_flow_schedules wfs,

2094: wfs.scheduled_completion_date,
2095: wfs.build_sequence,
2096: wfs.line_id,
2097: wil.line_code
2098: FROM wip_flow_schedules wfs,
2099: wip_lines wil
2100: WHERE demand_source_line = p_Top_Assembly_LineId
2101: AND wfs.line_id = wil.line_id;
2102:

Line 2265: FROM wip_flow_schedules

2261: build_sequence,
2262: line_id,
2263: synch_schedule_num,
2264: SYNCH_OPERATION_SEQ_NUM
2265: FROM wip_flow_schedules
2266: where demand_source_line = p_Top_Assembly_LineId;
2267:
2268: END IF;
2269:

Line 2867: FROM wip_flow_schedules

2863: build_sequence,
2864: line_id,
2865: synch_schedule_num,
2866: SYNCH_OPERATION_SEQ_NUM
2867: FROM wip_flow_schedules
2868: where primary_item_id = l_mlsupply_items(l_index).item_id
2869: and synch_schedule_num in
2870: ( Select schedule_number
2871: from BOM_CTO_MLSUPPLY_FLOW_TEMP