DBA Data[Home] [Help]

APPS.CST_MGD_LIFO_COST_PROCESSOR dependencies on CST_COST_TYPES

Line 1619: cst_cost_types cct

1615: WHERE (cpp.period_name, cpp.cost_type_id) =
1616: ( SELECT cpici.period_name,
1617: cct.cost_type_id
1618: FROM cst_pc_item_cost_interface cpici,
1619: cst_cost_types cct
1620: WHERE cpici.interface_header_id = p_interface_header_id
1621: AND cpici.cost_type = cct.cost_type
1622: )
1623: AND cpp.open_flag = 'N';

Line 1737: FROM cst_cost_types cct,

1733: ELSE
1734: IF l_cost_group IS NULL THEN -- First record fetched
1735: SELECT clct.primary_cost_method
1736: INTO l_primary_cost_method
1737: FROM cst_cost_types cct,
1738: cst_le_cost_types clct
1739: WHERE cct.cost_type_id = clct.cost_type_id
1740: AND clct.legal_entity =
1741: (SELECT DISTINCT ccg.legal_entity

Line 1881: FROM cst_cost_types cct,

1877: EXIT;
1878: ELSE
1879: SELECT clct.primary_cost_method
1880: INTO l_primary_cost_method
1881: FROM cst_cost_types cct,
1882: cst_le_cost_types clct
1883: WHERE cct.cost_type_id = clct.cost_type_id
1884: AND clct.legal_entity =
1885: (SELECT DISTINCT ccg.legal_entity

Line 1913: FROM cst_cost_types

1909: -- The lifo processor requires the cost type id
1910:
1911: SELECT cost_type_id
1912: INTO l_cost_type_id
1913: FROM cst_cost_types
1914: WHERE cost_type = RECINTERFACE.cost_type;
1915:
1916: -- find the first period to calculate from
1917: