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.CST_MGD_LIFO_COST_PROCESSOR dependencies on CST_PC_ITEM_COST_INTERFACE

Line 1618: FROM cst_pc_item_cost_interface cpici,

1614: FROM cst_pac_periods cpp
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: )

Line 1627: UPDATE cst_pc_item_cost_interface cpici

1623: AND cpp.open_flag = 'N';
1624:
1625: l_stmt_num := 2;
1626:
1627: UPDATE cst_pc_item_cost_interface cpici
1628: SET cpici.pac_period_id = p_pac_period_id
1629: WHERE cpici.interface_header_id = p_interface_header_id;
1630:
1631: l_stmt_num := 3;

Line 1635: FROM cst_pc_item_cost_interface cpici

1631: l_stmt_num := 3;
1632:
1633: SELECT count(*)
1634: INTO l_count
1635: FROM cst_pc_item_cost_interface cpici
1636: WHERE cpici.pac_period_id = p_pac_period_id
1637: AND (cpici.inventory_item_id,cpici.cost_group,cpici.cost_type) IN
1638: (
1639: SELECT inventory_item_id, cost_group , cost_type

Line 1640: FROM cst_pc_item_cost_interface

1636: WHERE cpici.pac_period_id = p_pac_period_id
1637: AND (cpici.inventory_item_id,cpici.cost_group,cpici.cost_type) IN
1638: (
1639: SELECT inventory_item_id, cost_group , cost_type
1640: FROM cst_pc_item_cost_interface
1641: WHERE interface_header_id = p_interface_header_id
1642: );
1643:
1644: IF l_count > 1 THEN

Line 1704: FROM cst_pc_item_cost_interface

1700: cost_type,
1701: inventory_item_id,
1702: begin_layer_quantity,
1703: layer_quantity
1704: FROM cst_pc_item_cost_interface
1705: WHERE interface_group_id = a_interface_group_id
1706: ORDER BY cost_group, cost_type, inventory_item_id, pac_period_id;
1707:
1708: RECINTERFACE c_interface%ROWTYPE;

Line 1748: FROM cst_pc_item_cost_interface cpici

1744: WHERE ccg.cost_group_id = ccga.cost_group_id
1745: AND ccg.cost_group_type = 2
1746: AND ccg.cost_group IN
1747: (SELECT cpici.cost_group
1748: FROM cst_pc_item_cost_interface cpici
1749: WHERE cpici.interface_header_id =
1750: RECINTERFACE.interface_header_id
1751: )
1752: )

Line 1755: FROM cst_pc_item_cost_interface cpici

1751: )
1752: )
1753: AND cct.cost_type IN
1754: (SELECT cpici.cost_type
1755: FROM cst_pc_item_cost_interface cpici
1756: WHERE cpici.interface_header_id =
1757: RECINTERFACE.interface_header_id
1758: );
1759:

Line 1762: FROM cst_pc_item_cost_interface cpici

1758: );
1759:
1760: SELECT cpici.begin_layer_quantity
1761: INTO l_initial_quantity
1762: FROM cst_pc_item_cost_interface cpici
1763: WHERE cpici.interface_header_id =
1764: RECINTERFACE.interface_header_id;
1765:
1766: IF l_primary_cost_method <> 4 OR l_initial_quantity <> 0 THEN

Line 1783: UPDATE cst_pc_item_cost_interface

1779: ||'begin layer quantity not correct'
1780: ||' for interface_id='
1781: ||TO_CHAR(RECINTERFACE.interface_header_id),1,240);
1782:
1783: UPDATE cst_pc_item_cost_interface
1784: SET process_flag = 3,
1785: error_flag = 22,
1786: error_explanation = 'Begin layer quantity not correct for LIFO record'
1787: WHERE interface_header_id = RECINTERFACE.interface_header_id;

Line 1844: FROM cst_pc_item_cost_interface

1840: cost_group_id,
1841: cost_type,
1842: inventory_item_id,
1843: interface_header_id
1844: FROM cst_pc_item_cost_interface
1845: WHERE interface_group_id = a_interface_group_id
1846: ORDER BY cost_group, cost_type, inventory_item_id, pac_period_id;
1847:
1848: RECINTERFACE c_interface%ROWTYPE;

Line 1892: FROM cst_pc_item_cost_interface cpici

1888: WHERE ccg.cost_group_id = ccga.cost_group_id
1889: AND ccg.cost_group_type = 2
1890: AND ccg.cost_group IN
1891: (SELECT cpici.cost_group
1892: FROM cst_pc_item_cost_interface cpici
1893: WHERE cpici.interface_header_id =
1894: RECINTERFACE.interface_header_id
1895: )
1896: )

Line 1899: FROM cst_pc_item_cost_interface cpici

1895: )
1896: )
1897: AND cct.cost_type IN
1898: (SELECT cpici.cost_type
1899: FROM cst_pc_item_cost_interface cpici
1900: WHERE cpici.interface_header_id =
1901: RECINTERFACE.interface_header_id
1902: );
1903: