eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_LOT_COSTING_PUB dependencies on CM_CMPT_DTL

Line 1373: FROM cm_cmpt_dtl cst,

1369: , p_date DATE
1370: )
1371: IS
1372: SELECT sum(cst.cmpnt_cost)
1373: FROM cm_cmpt_dtl cst,
1374: gmf_period_statuses gps
1375: WHERE gps.legal_entity_id = p_le_id
1376: AND gps.cost_type_id = p_cost_type_id
1377: AND gps.start_date <= p_date

Line 1415: FROM cm_cmpt_dtl cst

1411: (SELECT cst.cost_cmpntcls_id,
1412: cst.cost_analysis_code,
1413: 0 cost_level,
1414: SUM(cst.cmpnt_cost) cmpnt_cost
1415: FROM cm_cmpt_dtl cst
1416: WHERE cst.cost_type_id = p_cost_type_id
1417: AND cst.period_id = p_period_id
1418: AND cst.organization_id =
1419: (SELECT NVL (cstw.cost_organization_id, invw.organization_id)

Line 1452: FROM cm_cmpt_dtl cst,

1448: (SELECT cst.cost_cmpntcls_id,
1449: cst.cost_analysis_code,
1450: 0 cost_level,
1451: SUM(cst.cmpnt_cost) cmpnt_cost
1452: FROM cm_cmpt_dtl cst,
1453: gmf_period_statuses gps
1454: WHERE gps.legal_entity_id = p_le_id
1455: AND gps.cost_type_id = p_cost_type_id
1456: AND gps.start_date <= p_date

Line 5940: -- use the standard (period-based) cost from cm_cmpt_dtl,

5936: -- The transactions are sorted by date and then by line type. This should
5937: -- give the correct ordering of transactions for the rollup.
5938:
5939: -- If item is not lot controlled or is not lot costed
5940: -- use the standard (period-based) cost from cm_cmpt_dtl,
5941: -- otherwise use the lot cost
5942: -- B9131983
5943: IF l_step_tab(i).materials(j).line_type IN (-1,2) -- Treat byproducts as negative ingredients
5944: OR l_step_tab(i).materials(j).line_type = 1 AND l_step_tab(i).materials(j).lot_costed_flag = 0