DBA Data[Home] [Help]

APPS.PO_SOURCING3_SV SQL Statements

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

Line: 89

    SELECT fsp.inventory_organization_id,
	   ood.organization_code,
	   ood.organization_name,
	   fsp.set_of_books_id,
	   gsb.short_name,
	   gsb.currency_code,
	   gsb.chart_of_accounts_id,
	   psp.disposition_warning_flag,
	   psp.enforce_full_lot_quantities
    INTO   X_instance_org_id,
	   X_instance_org_code,
	   X_instance_org_name,
	   X_sob_id,
	   X_sob_short_name,
	   X_functional_currency_code,
	   X_chart_of_accounts_id,
	   X_disposition_warning_flag,
	   X_enforce_full_lot_control
    FROM   financials_system_parameters fsp,
	   gl_sets_of_books gsb,
	   org_organization_definitions ood,
	   po_system_parameters psp
    WHERE  fsp.set_of_books_id = gsb.set_of_books_id
    AND	   fsp.inventory_organization_id = ood.organization_id;