DBA Data[Home] [Help]

APPS.WIP_UPDATE_SETUP_RESOURCES dependencies on STANDARD

Line 182: bom_standard_operations bso

178: bsor.assigned_units,
179: bsor.schedule_flag,
180: bso.department_id
181: FROM bom_std_op_resources bsor,
182: bom_standard_operations bso
183: WHERE bsor.standard_operation_id = p_std_op_id
184: and bso.standard_operation_id = bsor.standard_operation_id;
185:
186: cursor instance_cursor(p_resource_id NUMBER,

Line 183: WHERE bsor.standard_operation_id = p_std_op_id

179: bsor.schedule_flag,
180: bso.department_id
181: FROM bom_std_op_resources bsor,
182: bom_standard_operations bso
183: WHERE bsor.standard_operation_id = p_std_op_id
184: and bso.standard_operation_id = bsor.standard_operation_id;
185:
186: cursor instance_cursor(p_resource_id NUMBER,
187: p_dept_id NUMBER) IS

Line 184: and bso.standard_operation_id = bsor.standard_operation_id;

180: bso.department_id
181: FROM bom_std_op_resources bsor,
182: bom_standard_operations bso
183: WHERE bsor.standard_operation_id = p_std_op_id
184: and bso.standard_operation_id = bsor.standard_operation_id;
185:
186: cursor instance_cursor(p_resource_id NUMBER,
187: p_dept_id NUMBER) IS
188: select instance_id,

Line 305: standard_rate_flag,

301: resource_id,
302: uom_code,
303: basis_type,
304: activity_id,
305: standard_rate_flag,
306: usage_rate_or_amount,
307: scheduled_flag,
308: assigned_units,
309: autocharge_type,

Line 334: wor.standard_rate_flag,

330: l_resource_id,
331: 'MIN',
332: 2, -- basis type: PER_LOT
333: wor.activity_id,
334: wor.standard_rate_flag,
335: l_transition_time, -- usage_rate_or_amount
336: 1, -- scheduled_flag: YES
337: wor.assigned_units,
338: wor.autocharge_type,

Line 407: standard_rate_flag,

403: resource_id,
404: uom_code,
405: basis_type,
406: activity_id,
407: standard_rate_flag,
408: usage_rate_or_amount,
409: scheduled_flag,
410: assigned_units,
411: autocharge_type,

Line 436: wor.standard_rate_flag,

432: setup_res_rec.resource_id,
433: 'MIN',
434: 2, -- basis type: PER_LOT
435: wor.activity_id,
436: wor.standard_rate_flag,
437: l_transition_time, -- usage_rate_or_amount
438: setup_res_rec.schedule_flag, -- scheduled_flag: YES
439: setup_res_rec.assigned_units,
440: wor.autocharge_type,