APPS.ISC_DBI_SUTIL_PKG SQL Statements

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

Line: 40

PROCEDURE update_col_name (p_dim_map IN out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map,
                           p_mv_set IN VARCHAR2,
			   p_dim_name VARCHAR2);

Line: 157

    update_col_name(l_dim_map,p_mv_set,p_view_by);

Line: 371

		(SELECT 1
		FROM org_access o
		WHERE o.responsibility_id = fnd_global.resp_id
		AND o.resp_application_id = fnd_global.resp_appl_id
		AND o.organization_id = fact.inv_org_id)
	OR EXISTS
		(SELECT 1
		FROM mtl_parameters org
		WHERE org.organization_id = fact.inv_org_id
		AND NOT EXISTS
			(SELECT 1
			FROM org_access ora
			WHERE org.organization_id = ora.organization_id)))'
        END);

Line: 782

/*  update_col_name

    Update the name of the viewby dimension columns the report will
    hit in the MVs.
*/
PROCEDURE update_col_name (p_dim_map IN out NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map, p_mv_set IN VARCHAR2, p_dim_name VARCHAR2)
IS

  l_pcat_val VARCHAR2 (120);

Line: 831

END update_col_name;

Line: 851

            WHEN 'ORGANIZATION+ORGANIZATION' THEN '(select organization_id id, name value from hr_all_organization_units_tl where language = userenv(''LANG''))'
            WHEN 'ORGANIZATION+OPI_INV_UNSEC_ORGANIZATION' THEN 'opi_inv_unsec_organizations_v'
            WHEN 'CUSTOMER+FII_CUSTOMERS' THEN 'fii_customers_v'
            WHEN 'ITEM+ENI_ITEM_VBH_CAT' THEN 'eni_item_vbh_nodes_v'
            WHEN 'ISC_TRANSPORTATION_MODE+ISC_TRANSPORTATION_MODE' THEN 'isc_transportation_mode_v'
            WHEN 'ISC_FREIGHT_CARRIER+ISC_FREIGHT_CARRIER' THEN 'isc_freight_carrier_v'
            WHEN 'ISC_CARRIER_SERVICE_LEVEL+ISC_CARRIER_SERVICE_LEVEL' THEN 'isc_carrier_service_level_v'
            WHEN 'ISC_SHIPMENT_DIRECTION+ISC_SHIPMENT_DIRECTION' THEN 'isc_shipment_direction_v'
	    WHEN 'ORGANIZATION+ORGANIZATION_SUBINVENTORY' THEN 'opi_subinventories_v'
            ELSE ''
        END);

Line: 1004

FUNCTION get_view_by_select_clause (p_viewby IN VARCHAR2)
    RETURN VARCHAR2
IS
    l_view_by_sel VARCHAR2(200);

Line: 1053

END get_view_by_select_clause;

Line: 1604

FUNCTION get_fact_select_columns (p_join_tbl IN
                                  poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
    RETURN VARCHAR2
IS
    l_fact_select_cols VARCHAR2(400);

Line: 1611

    l_fact_select_cols := '';

Line: 1616

            l_fact_select_cols := l_fact_select_cols ||
                                  p_join_tbl(l_num).fact_column || ',
                                  ';

Line: 1622

    l_fact_select_cols := rtrim (l_fact_select_cols, ',
                                                       ') || ' ';

Line: 1625

    return l_fact_select_cols;

Line: 1627

END get_fact_select_columns;

Line: 1638

    select gu_weight_uom into l_weight_uom from wsh_global_parameters;

Line: 1653

    select gu_volume_uom into l_volume_uom from wsh_global_parameters;

Line: 1668

    select gu_distance_uom into l_distance_uom from wsh_global_parameters;