DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on WIP_EAM_PARAMETERS

Line 864: FROM wip_eam_parameters

860:
861: ELSE
862: SELECT def_maint_cost_category
863: INTO l_maint_cost_category
864: FROM wip_eam_parameters
865: WHERE organization_id = p_org_id;
866:
867: END IF;
868:

Line 1931: FROM wip_eam_parameters

1927: ELSE
1928: l_stmt_num := 210;
1929: SELECT def_eam_cost_element_id
1930: into l_eam_cost_element
1931: FROM wip_eam_parameters
1932: WHERE organization_id = p_org_id;
1933: END IF; -- end checking resource type
1934: END IF; -- end checking txn mode
1935:

Line 2023: -- wip_eam_parameters.

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: --
2025: -- (anjgupta) If no operation dept is identified(eg if there is no routing)
2026: -- use the Work order owning dept for costing
2027:

Line 2033: -- category from wip_eam_parameters later on.

2029: -- Initialize return status to success.
2030: x_return_status := FND_API.G_RET_STS_SUCCESS;
2031:
2032: -- Get organization id, just in case we need to get default cost
2033: -- category from wip_eam_parameters later on.
2034: l_stmt_num := 215;
2035: SELECT entity_type,
2036: organization_id
2037: INTO l_entity_type,

Line 2133: FROM wip_eam_parameters

2129: IF l_maint_cost_category IS NULL THEN
2130: l_stmt_num := 280;
2131: SELECT def_maint_cost_category
2132: INTO l_maint_cost_category
2133: FROM wip_eam_parameters
2134: WHERE organization_id = l_organization_id;
2135: END IF;
2136:
2137: x_owning_dept := l_owning_dept_id;