DBA Data[Home] [Help]

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on CST_PER_CLOSE_SUMMARY_TEMP

Line 1787: INTO cst_per_close_summary_temp(

1783: );
1784:
1785: l_stmt_num := 54;
1786: INSERT
1787: INTO cst_per_close_summary_temp(
1788: cost_group_id,
1789: subinventory_code,
1790: inventory_item_id,
1791: accounted_value,

Line 1865: FROM cst_per_close_summary_temp CPCST

1861: CPCST.cost_group_id,
1862: CPCST.subinventory_code,
1863: CPCST.inventory_item_id,
1864: CPCST.rollback_onhand_value
1865: FROM cst_per_close_summary_temp CPCST
1866: WHERE CPCST.rollback_onhand_value <> 0
1867:
1868: UNION ALL
1869:

Line 1876: FROM cst_per_close_summary_temp CPCST

1872: CPCST.cost_group_id,
1873: CPCST.subinventory_code,
1874: CPCST.inventory_item_id,
1875: CPCST.rollback_intransit_value
1876: FROM cst_per_close_summary_temp CPCST
1877: WHERE CPCST.rollback_intransit_value <> 0
1878:
1879: UNION ALL
1880:

Line 1887: FROM cst_per_close_summary_temp CPCST

1883: CPCST.cost_group_id,
1884: CPCST.subinventory_code,
1885: CPCST.inventory_item_id,
1886: CPCST.rollback_onhand_value
1887: FROM cst_per_close_summary_temp CPCST
1888: WHERE CPCST.rollback_onhand_value <> 0
1889:
1890: UNION ALL
1891:

Line 1898: FROM cst_per_close_summary_temp CPCST

1894: CPCST.cost_group_id,
1895: CPCST.subinventory_code,
1896: CPCST.inventory_item_id,
1897: CPCST.rollback_intransit_value
1898: FROM cst_per_close_summary_temp CPCST
1899: WHERE CPCST.rollback_intransit_value <> 0;
1900:
1901: l_stmt_num := 59;
1902: IF (p_simulation = 1) THEN

Line 1903: DELETE cst_per_close_summary_temp;

1899: WHERE CPCST.rollback_intransit_value <> 0;
1900:
1901: l_stmt_num := 59;
1902: IF (p_simulation = 1) THEN
1903: DELETE cst_per_close_summary_temp;
1904: END IF;
1905:
1906: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1907: THEN

Line 2315: INTO cst_per_close_summary_temp(

2311: l_stmt_num := 110;
2312: x_return_status := '3';
2313: --period open -> CPCST (simulation)
2314: INSERT
2315: INTO cst_per_close_summary_temp(
2316: cost_group_id,
2317: subinventory_code,
2318: inventory_item_id,
2319: accounted_value,