APPS.CST_EAMCOST_PUB dependencies on BOM_DEPARTMENTS

Line 847: FROM bom_departments

843: l_stmt_num := 72;
844:
845: SELECT decode(maint_cost_category,NULL,0,1)
846: INTO l_check_category
847: FROM bom_departments
848: WHERE department_id = l_owning_dept_id;
849:
850: IF(l_debug = 'Y')THEN
851: fnd_file.put_line(fnd_file.log, 'l_check_category'||l_check_category);

Line 858: FROM bom_departments

854: IF(l_check_category=1) THEN
855:
856: SELECT maint_cost_category
857: INTO l_maint_cost_category
858: FROM bom_departments
859: WHERE department_id = l_owning_dept_id;
860:
861: ELSE
862: SELECT def_maint_cost_category

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

2016: -- phantom operation.)
2017: -- Owning dept = identify from bdr.share_from_dept_id
2018: --
2019: -- Department maintenance cost category.
2020: -- Identify from bom_departments. If null for owning dept, get it
2021: -- for wip_discrete_jobs.owning_department_id. If there is still
2022: -- no maintenance cost cat, get the default cost cat from
2023: -- wip_eam_parameters.
2024: --

Line 2062: FROM bom_departments bd,

2058: IF l_ops_exists <> 0 THEN -- have operation
2059: l_stmt_num := 230;
2060: SELECT bd.department_id
2061: INTO l_dept_id
2062: FROM bom_departments bd,
2063: wip_operations wo
2064: WHERE bd.department_id = wo.department_id
2065: AND wo.wip_entity_id = p_wip_entity_id
2066: AND wo.operation_seq_num = p_opseq_num;

Line 2121: FROM bom_departments

2117: IF l_owning_dept_id is NOT NULL THEN -- have department
2118: l_stmt_num := 270;
2119: SELECT maint_cost_category
2120: INTO l_maint_cost_category
2121: FROM bom_departments
2122: WHERE department_id = l_owning_dept_id;
2123:
2124: END IF; -- end checking dept
2125: END IF; -- end checking wip_entity_type

Line 6621: bom_departments bd

6617: bd.department_code
6618: into l_directItem_rec.department_id,
6619: l_directitem_rec.department_code
6620: from wip_operations wo,
6621: bom_departments bd
6622: where wo.wip_entity_id = l_directItem_rec.wip_entity_id
6623: and wo.operation_seq_num = l_directItem_rec.operation_seq_num
6624: and wo.organization_id = l_directItem_rec.organization_id
6625: and bd.department_id = wo.department_id;