DBA Data[Home] [Help]

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on CST_PER_CLOSE_SUMMARY_TEMP

Line 1744: INTO cst_per_close_summary_temp(

1740: );
1741:
1742: l_stmt_num := 54;
1743: INSERT
1744: INTO cst_per_close_summary_temp(
1745: cost_group_id,
1746: subinventory_code,
1747: inventory_item_id,
1748: accounted_value,

Line 1817: FROM cst_per_close_summary_temp CPCST

1813: CPCST.cost_group_id,
1814: CPCST.subinventory_code,
1815: CPCST.inventory_item_id,
1816: CPCST.rollback_onhand_value
1817: FROM cst_per_close_summary_temp CPCST
1818: WHERE CPCST.rollback_onhand_value <> 0
1819:
1820: UNION ALL
1821:

Line 1828: FROM cst_per_close_summary_temp CPCST

1824: CPCST.cost_group_id,
1825: CPCST.subinventory_code,
1826: CPCST.inventory_item_id,
1827: CPCST.rollback_intransit_value
1828: FROM cst_per_close_summary_temp CPCST
1829: WHERE CPCST.rollback_intransit_value <> 0
1830:
1831: UNION ALL
1832:

Line 1839: FROM cst_per_close_summary_temp CPCST

1835: CPCST.cost_group_id,
1836: CPCST.subinventory_code,
1837: CPCST.inventory_item_id,
1838: CPCST.rollback_onhand_value
1839: FROM cst_per_close_summary_temp CPCST
1840: WHERE CPCST.rollback_onhand_value <> 0
1841:
1842: UNION ALL
1843:

Line 1850: FROM cst_per_close_summary_temp CPCST

1846: CPCST.cost_group_id,
1847: CPCST.subinventory_code,
1848: CPCST.inventory_item_id,
1849: CPCST.rollback_intransit_value
1850: FROM cst_per_close_summary_temp CPCST
1851: WHERE CPCST.rollback_intransit_value <> 0;
1852:
1853: l_stmt_num := 59;
1854: IF (p_simulation = 1) THEN

Line 1855: DELETE cst_per_close_summary_temp;

1851: WHERE CPCST.rollback_intransit_value <> 0;
1852:
1853: l_stmt_num := 59;
1854: IF (p_simulation = 1) THEN
1855: DELETE cst_per_close_summary_temp;
1856: END IF;
1857:
1858: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
1859: THEN

Line 2178: INTO cst_per_close_summary_temp(

2174: l_stmt_num := 110;
2175: x_return_status := '3';
2176: --period open -> CPCST (simulation)
2177: INSERT
2178: INTO cst_per_close_summary_temp(
2179: cost_group_id,
2180: subinventory_code,
2181: inventory_item_id,
2182: accounted_value,