APPS.CST_EAMCOST_PUB dependencies on BOM_DEPARTMENTS

Line 644: FROM bom_departments

640:
641: l_stmt_num := 72;
642: SELECT maint_cost_category
643: INTO l_maint_cost_category
644: FROM bom_departments
645: WHERE department_id = l_owning_dept_id;
646:
647: l_stmt_num := 73;
648: SELECT department_id

Line 1798: -- Identify from bom_departments. If null for owning dept, get it

1794: -- phantom operation.)
1795: -- Owning dept = identify from bdr.share_from_dept_id
1796: --
1797: -- Department maintenance cost category.
1798: -- Identify from bom_departments. If null for owning dept, get it
1799: -- for wip_discrete_jobs.owning_department_id. If there is still
1800: -- no maintenance cost cat, get the default cost cat from
1801: -- wip_eam_parameters.
1802: --

Line 1840: FROM bom_departments bd,

1836: IF l_ops_exists <> 0 THEN -- have operation
1837: l_stmt_num := 230;
1838: SELECT bd.department_id
1839: INTO l_dept_id
1840: FROM bom_departments bd,
1841: wip_operations wo
1842: WHERE bd.department_id = wo.department_id
1843: AND wo.wip_entity_id = p_wip_entity_id
1844: AND wo.operation_seq_num = p_opseq_num;

Line 1899: FROM bom_departments

1895: IF l_owning_dept_id is NOT NULL THEN -- have department
1896: l_stmt_num := 270;
1897: SELECT maint_cost_category
1898: INTO l_maint_cost_category
1899: FROM bom_departments
1900: WHERE department_id = l_owning_dept_id;
1901:
1902: END IF; -- end checking dept
1903: END IF; -- end checking wip_entity_type

Line 6267: bom_departments bd

6263: bd.department_code
6264: into l_directItem_rec.department_id,
6265: l_directitem_rec.department_code
6266: from wip_operations wo,
6267: bom_departments bd
6268: where wo.wip_entity_id = l_directItem_rec.wip_entity_id
6269: and wo.operation_seq_num = l_directItem_rec.operation_seq_num
6270: and wo.organization_id = l_directItem_rec.organization_id
6271: and bd.department_id = wo.department_id;