APPS.CSTPUTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

	SELECT	NVL(FC.minimum_accountable_unit,
			POWER(10,NVL(-precision,0))),
		precision,
		extended_precision
	INTO	O_ROUND_UNIT, O_PRECISION, O_EXT_PREC
	FROM	fnd_currencies FC,
		gl_sets_of_books SOB,
		/*org_organization_definitions O */
                hr_organization_information O
        WHERE	O.organization_id = I_ORG_ID
	/*AND	O.set_of_books_id = SOB.set_of_books_id */
        AND     O.org_information1 = to_char(SOB.set_of_books_id)
        AND     O.org_information_context = 'Accounting Information'
	AND	SOB.currency_code = FC.currency_code
	AND	FC.enabled_flag = 'Y';

Line: 97

    select description
    into   l_item_description
    from   mtl_system_items
    where  inventory_item_id = Inv_item_id_in
    and    organization_id = Org_id_in;

Line: 131

    select primary_uom_code
    into   l_item_puom
    from   mtl_system_items
    where  inventory_item_id = Inv_item_id_in
    and    organization_id = Org_id_in;

Line: 148

Procedure execute_insert_CIT(
                             p_view_name IN varchar2,
                             p_cost_org_id IN NUMBER,
                             p_ct_id       IN NUMBER,
                             p_item_id     IN NUMBER,
                             p_app_col_name IN VARCHAR2,
                             p_flex        IN NUMBER) IS

fptr    utl_file.file_type;

Line: 163

   	'BEGIN Insert into CST_INQUIRY_TEMP '||
	' ( SESSION_ID, INVENTORY_ITEM_ID, '||
	' ORGANIZATION_ID, '||
	' COST_TYPE_ID, '||
	' ITEM_COST, '||
	' THIS_LEVEL_COSTS, '||
	' PREVIOUS_LEVEL_COSTS, '||
 	' GUI_DESCRIPTION) '||
	' SELECT '||
	'SESSION_ID, INVENTORY_ITEM_ID '||
	', ORGANIZATION_ID '||
	', COST_TYPE_ID '||
	', SUM(ITEM_COST) '||
	', SUM(THIS_LEVEL_COSTS) '||
	', SUM(PREVIOUS_LEVEL_COSTS) '||
	','||
	p_app_col_name||
   	' FROM '||
	p_view_name||
    	' WHERE ORGANIZATION_ID =' ||
        ':cost_org_id' ||
	' AND COST_TYPE_ID='||
	':ct_id' ||
	' AND INVENTORY_ITEM_ID='||
	':item_id' ||
	' GROUP BY SESSION_ID, INVENTORY_ITEM_ID, '||
	' ORGANIZATION_ID, COST_TYPE_ID, '||
	p_app_col_name || '; END;';

Line: 195

	  'BEGIN Insert into CST_INQUIRY_TEMP '||
	  '( SESSION_ID, INVENTORY_ITEM_ID, '||
	  'ORGANIZATION_ID, '||
	  'COST_TYPE_ID, OPERATION_SEQ_NUM, '||
	  'OPERATION_SEQUENCE_ID, DEPARTMENT_ID, '||
	  'ACTIVITY_ID, RESOURCE_ID, '||
	  'ITEM_COST, '||
	  'COST_ELEMENT_ID, '||
	  'THIS_LEVEL_COSTS, '||
	  'PREVIOUS_LEVEL_COSTS, '||
	  'VALUE_ADDED_ACTIVITY_FLAG, '||
	  'GUI_COLUMN1, GUI_COLUMN2, '||
	  'GUI_DESCRIPTION ) '||
	  'SELECT '||
	  'SESSION_ID, INVENTORY_ITEM_ID, '||
	  'ORGANIZATION_ID, '||
	  'COST_TYPE_ID, OPERATION_SEQ_NUM, '||
	  'OPERATION_SEQUENCE_ID, DEPARTMENT_ID, '||
	  'ACTIVITY_ID, RESOURCE_ID, '||
	  'NVL(ITEM_COST,0), '||
	  'COST_ELEMENT_ID, '||
	  'NVL(THIS_LEVEL_COSTS,0), '||
	  'NVL(PREVIOUS_LEVEL_COSTS,0), '||
	  'NULL, '||
	  'GUI_COLUMN1, GUI_COLUMN2, '||
	  'GUI_DESCRIPTION '||
	  'FROM '||
	  p_view_name ||
	  ' WHERE ORGANIZATION_ID =' ||
          ':cost_org_id' ||
	  ' AND COST_TYPE_ID='||
	  ':ct_id' ||
	  ' AND INVENTORY_ITEM_ID='||
          ':item_id; END;';

Line: 237

END execute_insert_CIT;