APPS.INV_INVIRITD_XMLP_PKG SQL Statements

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

Line: 28

      SELECT
        DISTINCT
        MEANING
      INTO P_YES_VALUE
      FROM
        FND_LOOKUP_VALUES
      WHERE LOOKUP_CODE = 'Y'
        AND LOOKUP_TYPE = 'YES_NO'
        AND LANGUAGE = USERENV('LANG')
        AND VIEW_APPLICATION_ID = 0;

Line: 38

      SELECT
        DISTINCT
        MEANING
      INTO P_NO_VALUE
      FROM
        FND_LOOKUP_VALUES
      WHERE LOOKUP_CODE = 'N'
        AND LOOKUP_TYPE = 'YES_NO'
        AND LANGUAGE = USERENV('LANG')
        AND VIEW_APPLICATION_ID = 0;

Line: 142

        SELECT
          count(*),
          MAX(CATEGORY_FLEX_STRUCTURE)
        INTO P_FA_INSTALLED,P_ACAT_STRUCT_NUM
        FROM
          FA_SYSTEM_CONTROLS;

Line: 252

      RETURN ('/* Do not select general information */');

Line: 330

      RETURN (' /* Do not select BOM info */ ');

Line: 371

      RETURN ('/* Do not select Costing Options */');

Line: 397

             	,decode(msi.ALLOW_ITEM_DESC_UPDATE_FLAG,''Y'',' || '''' || P_YES_VALUE || '''' || ',''N'',' || '''' || P_NO_VALUE || '''' || ',NULL)	Allow_description_update
             	,MSI.market_price	Market_price
             	,INV_MEANING_SEL.c_po_un_numb(msi.UN_NUMBER_ID)	UN_number
             	,INV_MEANING_SEL.C_PO_HAZARD_CLASS(msi.HAZARD_CLASS_ID)	Hazard_Class
             	,decode(msi.RFQ_REQUIRED_FLAG,''Y'',' || '''' || P_YES_VALUE || '''' || ',''N'',' || '''' || P_NO_VALUE || '''' || ',NULL)		RFQ_Required
             	,MSI.list_price_per_unit	List_price
             	,MSI.PRICE_TOLERANCE_PERCENT	Price_tolerance_percent
             	,' || P_PO_ACAT_FLEX || '		C_acat_flex
             	,decode(msi.OUTSIDE_OPERATION_FLAG,''Y'',' || '''' || P_YES_VALUE || '''' || ',''N'',' || '''' || P_NO_VALUE || '''' || ',NULL)	Outside_Operation
             	,MSI.OUTSIDE_OPERATION_UOM_TYPE	Outside_Operation_Unit_Type
             	,MSI.ROUNDING_FACTOR		Rounding_Factor
             	,MSI.UNIT_OF_ISSUE		Unit_of_Issue
             	,' || P_PO_EXP_ACCT_FLEX || '	Expense_Account
             	,' || P_PO_ENC_ACCT_FLEX || '	Encumbrance_Account
             	,INV_MEANING_SEL.C_PER_PEOPLE(msi.buyer_id)	Default_Buyer
             	,decode(msi.PURCHASING_ENABLED_FLAG,''Y'',' || '''' || P_YES_VALUE || '''' || ',''N'',' || '''' || P_NO_VALUE || '''' || ',NULL)		Purchasable
             	,msi.purchasing_tax_code	Purchasing_tax_code
             ');

Line: 424

             	,''x''	Allow_description_update
             	,  0	Market_price
             	,''x''		UN_number
             	,''x''	Hazard_Class
             	,''x''	RFQ_Required
             	,  0	List_price
             	,  0	Price_tolerance_percent
             	,''x''		C_acat_flex
             	,''x''		Outside_Operation
             	,''x''	Outside_Operation_Unit_Type
             	,  0		Rounding_Factor
             	,''x''		Unit_of_Issue
             	,''x''	Expense_Account
             	,''x''	Encumbrance_Account
             	,''x''			Default_Buyer
             	,''x''		Purchasable
             	,''x''		Purchasing_tax_code
                    ');

Line: 452

      RETURN ('/* Do not select Purchasing Options */');

Line: 503

      RETURN ('/* Do not select Receiving Group Options*/');

Line: 619

      RETURN ('/* Do not select General Planning Group Option */');

Line: 711

      RETURN ('/*Do not select MPS/MRP Planning Group Options */');

Line: 757

      RETURN ('/* Do not select WIP Group Options */');

Line: 832

      RETURN ('/* Do not select OE Group Option */');

Line: 874

      RETURN ('/* Do not select Invoice Group Options */');

Line: 899

        SELECT
          CATEGORY_SET_NAME
        INTO NAME
        FROM
          MTL_CATEGORY_SETS_VL
        WHERE CATEGORY_SET_ID = SET_ID;

Line: 926

      RETURN ('/* Do not select OE Group Option */');

Line: 1016

      SELECT
        FLU.MEANING
      INTO TEMP
      FROM
        FND_LOOKUPS FLU
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'Y';

Line: 1025

      SELECT
        FLU.MEANING
      INTO TEMP
      FROM
        FND_LOOKUPS FLU
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'N';

Line: 1043

      SELECT
        FLU.MEANING
      INTO TEMP
      FROM
        FND_LOOKUPS FLU
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'Y';

Line: 1052

      SELECT
        FLU.MEANING
      INTO TEMP
      FROM
        FND_LOOKUPS FLU
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'N';

Line: 1070

      SELECT
        FLU.MEANING
      INTO TEMP
      FROM
        FND_LOOKUPS FLU
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'Y';

Line: 1079

      SELECT
        FLU.MEANING
      INTO TEMP
      FROM
        FND_LOOKUPS FLU
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = 'N';

Line: 1097

      SELECT
        CLU.MEANING
      INTO TEMP
      FROM
        CS_LOOKUPS CLU
      WHERE LOOKUP_TYPE = 'MTL_SERVICE_BILLABLE_FLAG'
        AND LOOKUP_CODE = 'E';

Line: 1106

      SELECT
        CLU.MEANING
      INTO TEMP
      FROM
        CS_LOOKUPS CLU
      WHERE LOOKUP_TYPE = 'MTL_SERVICE_BILLABLE_FLAG'
        AND LOOKUP_CODE = 'L';

Line: 1115

      SELECT
        CLU.MEANING
      INTO TEMP
      FROM
        CS_LOOKUPS CLU
      WHERE LOOKUP_TYPE = 'MTL_SERVICE_BILLABLE_FLAG'
        AND LOOKUP_CODE = 'M';

Line: 1145

      RETURN ('/* Do not select Asset Group Options */');

Line: 1186

      RETURN ('/* Do not select OE Group Option */');

Line: 1340

      RETURN ('/* Do not select Inventory Group Options */');

Line: 1345

 FUNCTION C_INVC_SELECT(C_INVC_ACCT_FIELD VARCHAR2) RETURN VARCHAR2
  IS
 BEGIN
   IF P_BREAK_ID = 1 THEN
     RETURN(C_INVC_ACCT_FIELD);

Line: 1353

 END C_INVC_SELECT;

Line: 1355

 FUNCTION C_WIP_SELECT(C_WIP_LOC_FIELD VARCHAR2) RETURN VARCHAR2
 IS
 BEGIN
   IF (P_ALL_INFO = 1 OR P_WIP_INFO = 1 ) THEN
    RETURN( C_WIP_LOC_FIELD);

Line: 1363

END C_WIP_SELECT;

Line: 1365

FUNCTION C_ENC_SELECT(C_ENC_ACCT_FIELD VARCHAR2) RETURN VARCHAR2
IS
BEGIN
   IF (P_PO_INFO = 1 OR P_ALL_INFO = 1 )  THEN
    RETURN( C_ENC_ACCT_FIELD);

Line: 1373

END C_ENC_SELECT;

Line: 1375

FUNCTION C_EXP_SELECT(C_EXP_ACCT_FIELD VARCHAR2) RETURN VARCHAR2
IS
BEGIN
   IF (P_PO_INFO = 1 OR P_ALL_INFO = 1 )  THEN
    RETURN( C_EXP_ACCT_FIELD);

Line: 1383

END C_EXP_SELECT;

Line: 1385

FUNCTION C_ACAT_SELECT(C_ACAT_FIELD VARCHAR2) RETURN VARCHAR2
IS
BEGIN
   IF (P_PO_INFO = 1 OR P_ALL_INFO = 1 )  THEN
    RETURN( C_ACAT_FIELD);

Line: 1393

END C_ACAT_SELECT;

Line: 1395

FUNCTION C_CST_SELECT(C_CST_ACCT_FIELD VARCHAR2) RETURN VARCHAR2
IS
BEGIN
   IF (P_CST_INFO = 1 OR P_ALL_INFO = 1 ) THEN
    RETURN( C_CST_ACCT_FIELD);

Line: 1403

END C_CST_SELECT;