DBA Data[Home] [Help]

APPS.RCV_RETURN_SV dependencies on BOM_DEPARTMENTS

Line 336: bom_departments bd,

332: into x_wip_entity_name,
333: x_operation_seq_num,
334: x_department_code
335: from wip_entities we,
336: bom_departments bd,
337: wip_operation_resources wr,
338: wip_operations wn,
339: wip_operations wo
340: where wo.wip_entity_id = x_wip_entity_id

Line 385: FROM bom_departments bd,

381: begin
382: SELECT wn.operation_seq_num sequence,
383: bd.department_code department
384: INTO x_operation_seq_num, x_department_code
385: FROM bom_departments bd,
386: wip_operation_resources wr,
387: wip_operations wn,
388: wip_operations wo
389: WHERE wo.wip_entity_id = x_wip_entity_id

Line 417: from bom_departments bd,wip_operations wn

413: x_progress := 84;
414: begin
415: select bd.department_code department
416: into X_department_code
417: from bom_departments bd,wip_operations wn
418: where wn.wip_entity_id = x_wip_entity_id
419: and wn.organization_id = x_organization_id
420: and nvl(wn.repetitive_schedule_id, -1) =
421: nvl(x_wip_repetitive_schd_id, -1)