DBA Data[Home] [Help]

APPS.CSTPSCEX dependencies on CST_SC_LOW_LEVEL_CODES

Line 1327: insert into cst_sc_low_level_codes

1323: LOOP
1324:
1325: l_stmt_num := 10;
1326:
1327: insert into cst_sc_low_level_codes
1328: (
1329: ROLLUP_ID,
1330: INVENTORY_ITEM_ID,
1331: ORGANIZATION_ID,

Line 1413: delete cst_sc_low_level_codes CSLLC

1409: IF ( (l_frozen_standard_flag = 1) and (i_report_option_type <> -1 or i_report_option_type is null) ) THEN
1410:
1411: l_stmt_num := 40;
1412:
1413: delete cst_sc_low_level_codes CSLLC
1414: where
1415: CSLLC.rollup_id = i_rollup_id and
1416: exists
1417: (

Line 1664: from cst_sc_low_level_codes

1660: l_stmt_num := 76;
1661: IF ((l_report_levels IS NOT NULL) and (i_report_type_type = 2)) THEN
1662: select max(low_level_code)+2
1663: into l_report_levels
1664: from cst_sc_low_level_codes
1665: where rollup_id = l_rollup_id;
1666: END IF;
1667:
1668: