APPS.INV_INVARCTA_XMLP_PKG SQL Statements

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

Line: 81

	select first_value(cur.precision) over() into pstd_precision
	from org_organization_definitions org,
	gl_sets_of_books  gsob,
	fnd_currencies   cur
	where org.organization_id = p_org_id
	and  org.set_of_books_id = gsob.set_of_books_id
	and cur.currency_code = gsob.currency_code;

Line: 311

        SELECT
          CONVERSION_RATE
        INTO CUR_RATE
        FROM
          MTL_UOM_CONVERSIONS_VIEW
        WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
          AND ORGANIZATION_ID = TO_NUMBER(P_ORG_ID)
          AND PRIMARY_UOM_CODE = UOM
          AND UOM_CODE = COUNT_UOM_CURRENT;

Line: 336

        SELECT
          CONVERSION_RATE
        INTO PRIOR_RATE
        FROM
          MTL_UOM_CONVERSIONS_VIEW
        WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
          AND ORGANIZATION_ID = TO_NUMBER(P_ORG_ID)
          AND PRIMARY_UOM_CODE = UOM
          AND UOM_CODE = COUNT_UOM_PRIOR;

Line: 361

        SELECT
          CONVERSION_RATE
        INTO FIRST_RATE
        FROM
          MTL_UOM_CONVERSIONS_VIEW
        WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
          AND ORGANIZATION_ID = TO_NUMBER(P_ORG_ID)
          AND PRIMARY_UOM_CODE = UOM
          AND UOM_CODE = COUNT_UOM_FIRST;

Line: 410

          SELECT
            LICENSE_PLATE_NUMBER
          INTO X_OUTERMOST_LPN
          FROM
            WMS_LICENSE_PLATE_NUMBERS
          WHERE LPN_ID = L_OUTERMOST_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference

Line: 434

          SELECT
            LICENSE_PLATE_NUMBER
          INTO X_PARENT_LPN
          FROM
            WMS_LICENSE_PLATE_NUMBERS
          WHERE LPN_ID = L_PARENT_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference

Line: 457

        SELECT
          COST_GROUP
        INTO M_COST_GROUP
        FROM
          CST_COST_GROUPS
        WHERE COST_GROUP_ID = L_COST_GROUP_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference