DBA Data[Home] [Help]

APPS.GL_WEB_PLSQL_CARTRIDGE SQL Statements

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

Line: 19

  cons_child_set       VARCHAR2(1500);  -- Buffer for the select statement
Line: 52

         SELECT distinct to_ledger.ledger_id,
                to_ledger.name ||
			'\nCurrency: ' || to_ledger.currency_code ||
			'\nCalendar: ' || to_ledger.period_set_name ||
			'\nChart of Accounts: ',
		to_ledger.chart_of_accounts_id,
                cs1.name,
		from_ledger.ledger_id,
                from_ledger.name ||
			'\nCurrency: ' || from_ledger.currency_code ||
			'\nCalendar: ' || from_ledger.period_set_name ||
			'\nChart of Accounts: ',
		from_ledger.chart_of_accounts_id,
		cs2.consolidation_set_id, cs2.name
	 FROM
                gl_ledgers to_ledger,
		gl_ledgers from_ledger,
		gl_cons_set_assignments csa,
		gl_consolidation_sets cs1,
		gl_consolidation_sets cs2,
		gl_consolidation c
	 WHERE  cs1.consolidation_set_id = csa.consolidation_set_id
	 AND	csa.consolidation_id =  c.consolidation_id
	 AND 	c.from_ledger_id = from_ledger.ledger_id
	 AND	c.to_ledger_id = to_ledger.ledger_id
	 AND	cs2.consolidation_set_id(+) = csa.child_consolidation_set_id
	 AND	cs1.consolidation_set_id = X_Consolidation_Set_Id ;
Line: 81

         SELECT to_ledger.ledger_id,
                to_ledger.name ||
			'\nCurrency: ' || to_ledger.currency_code ||
			'\nCalendar: ' || to_ledger.period_set_name ||
			'\nChart of Accounts: ',
		to_ledger.chart_of_accounts_id,
                cs1.name,
		from_ledger.ledger_id,
                from_ledger.name ||
			'\nCurrency: ' || from_ledger.currency_code ||
			'\nCalendar: ' || from_ledger.period_set_name ||
			'\nChart of Accounts: ',
		from_ledger.chart_of_accounts_id,
		cs2.consolidation_set_id, cs2.name, c.name
	 FROM
                gl_ledgers to_ledger,
		gl_ledgers from_ledger,
		gl_consolidation c,
		gl_cons_set_assignments csa,
		gl_consolidation_sets cs1,
		gl_consolidation_sets cs2
	 WHERE  cs1.consolidation_set_id = csa.consolidation_set_id
	 AND	csa.consolidation_id =  c.consolidation_id
	 AND 	c.from_ledger_id = from_ledger.ledger_id
	 AND	c.to_ledger_id = to_ledger.ledger_id
	 AND	cs2.consolidation_set_id(+) = csa.child_consolidation_set_id
	 AND	cs1.consolidation_set_id = X_Consolidation_Set_Id ;
Line: 110

	SELECT  form_left_prompt
	FROM	fnd_id_flex_segments_tl
	WHERE	id_flex_num = coa
	AND	application_id = 101
	AND	id_flex_code = 'GL#'
	AND	language = userenv('LANG');
Line: 131

    SELECT name
    INTO   mapping_set_name
    FROM   GL_CONSOLIDATION_SETS
    WHERE  consolidation_set_id = X_Consolidation_Set_Id;
Line: 140

        SELECT description
        INTO   title
        FROM   GL_LOOKUPS
        WHERE  lookup_type = 'CONSOLIDATION_VIEWER'
        AND    lookup_code = 'CHV_TITLE';
Line: 146

        SELECT description
        INTO   gcs_title
        FROM   GL_LOOKUPS
        WHERE  lookup_type = 'CONSOLIDATION_VIEWER'
    AND    lookup_code = 'FEATURE_NAME';
Line: 152

    SELECT description
    INTO   gcs_message
    FROM   GL_LOOKUPS
    WHERE  lookup_type = 'CONSOLIDATION_VIEWER'
    AND    lookup_code = 'FEATURE_MESSAGE';
Line: 311

          cons_child_set := 'SELECT distinct to_ledger.ledger_id,to_ledger.name || ' ||
                                '''\nCurrency: ''' || ' || to_ledger.currency_code || ' ||
                                '''\nCalendar: ''' || '|| to_ledger.period_set_name || ' ||
                                '''\nChart of Accounts: ''' || ', ' ||
				'to_ledger.chart_of_accounts_id, ' ||
                                'cs1.name, ' ||
                                'from_ledger.ledger_id, from_ledger.name || ' ||
                                '''\nCurrency: ''' || ' || from_ledger.currency_code || ' ||
                                '''\nCalendar: ''' || '|| from_ledger.period_set_name || ' ||
                                '''\nChart of Accounts: ''' || ', ' ||
				'from_ledger.chart_of_accounts_id, ' ||
                                'cs2.consolidation_set_id, cs2.name ' ||
	                'FROM   gl_ledgers to_ledger, ' ||
		               'gl_ledgers from_ledger, ' ||
		               'gl_consolidation c, ' ||
		               'gl_cons_set_assignments csa, ' ||
		               'gl_consolidation_sets cs1, ' ||
		               'gl_consolidation_sets cs2 ' ||
	                'WHERE  cs1.consolidation_set_id = ' ||
			        'csa.consolidation_set_id ' ||
	                'AND    csa.consolidation_id = ' ||
			        'c.consolidation_id ' ||
	                'AND    c.from_ledger_id = ' ||
			        'from_ledger.ledger_id ' ||
	                'AND    c.to_ledger_id = ' ||
			        'to_ledger.ledger_id ' ||
	                'AND    cs2.consolidation_set_id(+) = csa.child_consolidation_set_id ' ||
	                'AND    cs1.consolidation_set_id IN ( ' || prior_child_set_id || ')' ;
Line: 340

          cons_child_set := 'SELECT distinct to_ledger.ledger_id,to_ledger.name || ' ||
                                '''\nCurrency: ''' || ' || to_ledger.currency_code || ' ||
                                '''\nCalendar: ''' || '|| to_ledger.period_set_name || ' ||
                                '''\nChart of Accounts: ''' || ', ' ||
				'to_ledger.chart_of_accounts_id, ' ||
                                'cs1.name, ' ||
                                'from_ledger.ledger_id, from_ledger.name || ' ||
                                '''\nCurrency: ''' || ' || from_ledger.currency_code || ' ||
                                '''\nCalendar: ''' || '|| from_ledger.period_set_name || ' ||
                                '''\nChart of Accounts: ''' || ', ' ||
				'from_ledger.chart_of_accounts_id, ' ||
                                'cs2.consolidation_set_id, cs2.name, c.name ' ||
	                'FROM   gl_ledgers to_ledger, ' ||
		               'gl_ledgers from_ledger, ' ||
		               'gl_consolidation c, ' ||
		               'gl_cons_set_assignments csa, ' ||
		               'gl_consolidation_sets cs1, ' ||
		               'gl_consolidation_sets cs2 ' ||
	                'WHERE  cs1.consolidation_set_id = ' ||
			        'csa.consolidation_set_id ' ||
	                'AND    csa.consolidation_id = ' ||
			        'c.consolidation_id ' ||
	                'AND    c.from_ledger_id = ' ||
			        'from_ledger.ledger_id ' ||
	                'AND    c.to_ledger_id = ' ||
			        'to_ledger.ledger_id ' ||
	                'AND    cs2.consolidation_set_id(+) = csa.child_consolidation_set_id ' ||
	                'AND    cs1.consolidation_set_id IN ( ' || prior_child_set_id || ')' ;
Line: 389

      temp_child_seg := 'SELECT  form_left_prompt ' ||
			'FROM	fnd_id_flex_segments_tl ' ||
			'WHERE	application_id = 101 '||
			'AND	id_flex_code = ''GL#'' ' ||
			'AND	language = userenv(''LANG'') ';