DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on WIP_EAM_PARAMETERS

Line 1709: FROM wip_eam_parameters

1705: ELSE
1706: l_stmt_num := 210;
1707: SELECT def_eam_cost_element_id
1708: into l_eam_cost_element
1709: FROM wip_eam_parameters
1710: WHERE organization_id = p_org_id;
1711: END IF; -- end checking resource type
1712: END IF; -- end checking txn mode
1713:

Line 1801: -- wip_eam_parameters.

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

Line 1811: -- category from wip_eam_parameters later on.

1807: -- Initialize return status to success.
1808: x_return_status := FND_API.G_RET_STS_SUCCESS;
1809:
1810: -- Get organization id, just in case we need to get default cost
1811: -- category from wip_eam_parameters later on.
1812: l_stmt_num := 215;
1813: SELECT entity_type,
1814: organization_id
1815: INTO l_entity_type,

Line 1911: FROM wip_eam_parameters

1907: IF l_maint_cost_category IS NULL THEN
1908: l_stmt_num := 280;
1909: SELECT def_maint_cost_category
1910: INTO l_maint_cost_category
1911: FROM wip_eam_parameters
1912: WHERE organization_id = l_organization_id;
1913: END IF;
1914:
1915: x_owning_dept := l_owning_dept_id;