DBA Data[Home] [Help]

APPS.RCV_RETURN_SV dependencies on BOM_DEPARTMENTS

Line 344: bom_departments bd,

340: into x_wip_entity_name,
341: x_operation_seq_num,
342: x_department_code
343: from wip_entities we,
344: bom_departments bd,
345: wip_operation_resources wr,
346: wip_operations wn,
347: wip_operations wo
348: where wo.wip_entity_id = x_wip_entity_id

Line 393: FROM bom_departments bd,

389: begin
390: SELECT wn.operation_seq_num sequence,
391: bd.department_code department
392: INTO x_operation_seq_num, x_department_code
393: FROM bom_departments bd,
394: wip_operation_resources wr,
395: wip_operations wn,
396: wip_operations wo
397: WHERE wo.wip_entity_id = x_wip_entity_id

Line 425: from bom_departments bd,wip_operations wn

421: x_progress := 84;
422: begin
423: select bd.department_code department
424: into X_department_code
425: from bom_departments bd,wip_operations wn
426: where wn.wip_entity_id = x_wip_entity_id
427: and wn.organization_id = x_organization_id
428: and nvl(wn.repetitive_schedule_id, -1) =
429: nvl(x_wip_repetitive_schd_id, -1)