APPS.PO_OPTIONS_SV SQL Statements

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

Line: 33

    SELECT     application_id
    INTO       po_id
    FROM       FND_APPLICATION
    WHERE      application_short_name = 'PO';

Line: 39

    SELECT     application_id
    INTO       oe_id
    FROM       FND_APPLICATION
    WHERE      application_short_name = 'OE';

Line: 45

    SELECT     application_id
    INTO       inv_id
    FROM       FND_APPLICATION
    WHERE      application_short_name = 'INV';

Line: 83

    SELECT 	sob.chart_of_accounts_id,
		fsp.inventory_organization_id,
		sob.currency_code
    INTO	coa,
		inventory_org_id,
		currency_code
    FROM	gl_sets_of_books sob,
		financials_system_parameters fsp
    WHERE 	sob.set_of_books_id = fsp.set_of_books_id;

Line: 112

    SELECT 	table_name
    INTO  	dummy_str
    FROM	all_tables alt
    WHERE	alt.table_name = 'PER_POSITION_STRUCTURES';

Line: 129

    SELECT 	table_name
    INTO 	dummy_str
    FROM	all_tables alt
    WHERE	alt.table_name = 'PO_DOCUMENT_TYPES';

Line: 150

    SELECT 	table_name
    INTO 	dummy_str
    FROM	all_tables alt
    WHERE	alt.table_name = 'SO_ORDER_TYPES_ALL';

Line: 167

    SELECT 	table_name
    INTO 	dummy_str
    FROM	all_tables alt
    WHERE	alt.table_name = 'SO_ORDER_SOURCES';

Line: 184

    SELECT 	table_name
    INTO 	dummy_str
    FROM	all_tables alt
    WHERE	alt.table_name = 'PO_LINE_TYPES';

Line: 201

    SELECT 	count(*)
    INTO 	data_exists
    FROM 	po_system_parameters;