DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_INFO dependencies on BOM_DEPARTMENTS

Line 29: bom_departments bd,

25: p_department_id,
26: p_prev_op_seq_num,
27: p_next_op_seq_num
28: from bom_standard_operations bso,
29: bom_departments bd,
30: wip_operations wo
31: where wo.organization_id = p_org_id
32: /* %cfm Ignore cfm ops. */
33: and nvl(bso.operation_type, 1) = 1

Line 111: bom_departments bd,

107: wo.minimum_transfer_quantity,
108: wo.quantity_waiting_to_move,
109: WIP_CONSTANTS.YES allow_moves
110: from bom_standard_operations bso,
111: bom_departments bd,
112: wip_operations wo
113: where wo.operation_seq_num =
114: (select max(operation_seq_num)
115: from wip_operations wo1

Line 162: bom_departments bd,

158: wo.minimum_transfer_quantity,
159: wo.quantity_waiting_to_move,
160: WIP_CONSTANTS.NO allow_moves
161: from bom_standard_operations bso,
162: bom_departments bd,
163: wip_operations wo
164: where wo.operation_seq_num =
165: (select max(operation_seq_num)
166: from wip_operations wo1

Line 274: bom_departments bd,

270: bso.operation_code,
271: wo.department_id,
272: bd.department_code
273: from bom_standard_operations bso,
274: bom_departments bd,
275: wip_operations wo
276: where wo.operation_seq_num =
277: (select min(operation_seq_num)
278: from wip_operations wo1