APPS.ONT_OEXOECOD_XMLP_PKG SQL Statements

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

Line: 8

      SELECT
        MEANING
      INTO ORDER_BY_DISPLAY
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'OEXOAPOA ORDER BY'
        AND LOOKUP_CODE = P_ORDER_BY;

Line: 52

    SELECT
      NAME
    INTO SOB_NAME
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = P_SOB_ID;

Line: 70

      SELECT
        MEANING
      INTO OPEN_ORDERS
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_OPEN_ORDERS;

Line: 88

    SELECT
      MIN(PHONE_AREA_CODE || '-' || PHONE_NUMBER)
    INTO PHONE
    FROM
      HZ_CONTACT_POINTS
    WHERE CONTACT_POINT_ID = CONTACT_ID;

Line: 106

      SELECT
        CURRENCY_CODE
      INTO BASE_CURRENCY
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = P_SOB_ID;

Line: 125

      SELECT
        MEANING
      INTO SC_DISPLAY
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_SALES_CREDITS;

Line: 145

      SELECT
        MEANING
      INTO PA_DISPLAY
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_ADJUSTMENTS;

Line: 165

      SELECT
        MEANING
      INTO FC_DISPLAY
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_FUNCTIONAL_CURRENCY;

Line: 221

        SELECT
          C_GL_CONV_RATE * OE_OE_TOTALS_SUMMARY.PRT_ORDER_TOTAL(HEADER_ID)
        INTO FC_ORDER_VALUE
        FROM
          DUAL;

Line: 258

        SELECT
          C_GL_CONV_RATE * HDR_PA_AMOUNT
        INTO FC_PA_AMOUNT
        FROM
          DUAL;

Line: 279

        SELECT
          C_GL_CONV_RATE * LIST_PRICE
        INTO FC_LIST_PRICE
        FROM
          DUAL;

Line: 315

        SELECT
          C_GL_CONV_RATE * SELLING_PRICE
        INTO FC_SELLING_PRICE
        FROM
          DUAL;

Line: 351

        SELECT
          C_GL_CONV_RATE * EXTENDED_PRICE
        INTO FC_EXTENDED_PRICE
        FROM
          DUAL;

Line: 386

        SELECT
          C_GL_CONV_RATE * L_PA_AMOUNT
        INTO FC_PA_AMOUNT
        FROM
          DUAL;

Line: 445

      SELECT
        MEANING
      INTO L_MEANING
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'REPORT_ORDER_CATEGORY'
        AND LOOKUP_CODE = P_ORDER_CATEGORY;

Line: 516

        SELECT
          OEOT.NAME
        INTO L_ORDER_TYPE_LOW
        FROM
          OE_TRANSACTION_TYPES_TL OEOT
        WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LO
          AND OEOT.LANGUAGE = USERENV('LANG');

Line: 523

        SELECT
          OEOT.NAME
        INTO L_ORDER_TYPE_HIGH
        FROM
          OE_TRANSACTION_TYPES_TL OEOT
        WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HI
          AND OEOT.LANGUAGE = USERENV('LANG');

Line: 533

          SELECT
            OEOT.NAME
          INTO L_ORDER_TYPE_HIGH
          FROM
            OE_TRANSACTION_TYPES_TL OEOT
          WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HI
            AND OEOT.LANGUAGE = USERENV('LANG');

Line: 543

            SELECT
              OEOT.NAME
            INTO L_ORDER_TYPE_LOW
            FROM
              OE_TRANSACTION_TYPES_TL OEOT
            WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LO
              AND OEOT.LANGUAGE = USERENV('LANG');

Line: 570

        SELECT
          OEOT.NAME
        INTO L_LINE_TYPE_HIGH
        FROM
          OE_TRANSACTION_TYPES_TL OEOT
        WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_HI
          AND OEOT.LANGUAGE = USERENV('LANG');

Line: 577

        SELECT
          OEOT.NAME
        INTO L_LINE_TYPE_LOW
        FROM
          OE_TRANSACTION_TYPES_TL OEOT
        WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_LO
          AND OEOT.LANGUAGE = USERENV('LANG');

Line: 587

          SELECT
            OEOT.NAME
          INTO L_LINE_TYPE_HIGH
          FROM
            OE_TRANSACTION_TYPES_TL OEOT
          WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_HI
            AND OEOT.LANGUAGE = USERENV('LANG');

Line: 597

            SELECT
              OEOT.NAME
            INTO L_LINE_TYPE_LOW
            FROM
              OE_TRANSACTION_TYPES_TL OEOT
            WHERE OEOT.TRANSACTION_TYPE_ID = P_LINE_TYPE_LO
              AND OEOT.LANGUAGE = USERENV('LANG');

Line: 701

        SELECT
          C_GL_CONV_RATE * NVL(TAX_ON_LINE
             ,0)
        INTO FC_TAX
        FROM
          DUAL;

Line: 722

        SELECT
          C_GL_CONV_RATE * ROUND(LINE_CHARGE
               ,2)
        INTO FC_LINE_CHARGE
        FROM
          DUAL;

Line: 854

        SELECT
          C_GL_CONV_RATE * SVC_EXTENDED_PRICE
        INTO FC_SVC_EXTENDED_PRICE
        FROM
          DUAL;

Line: 874

        SELECT
          C_GL_CONV_RATE * SVC_SELLING_PRICE
        INTO FC_SVC_SELLING_PRICE
        FROM
          DUAL;

Line: 897

      SELECT
        MEANING
      INTO L_MEANING
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'REPORT_LINE_DISPLAY'
        AND LOOKUP_CODE = P_LINE_CATEGORY;

Line: 917

      SELECT
        MEANING
      INTO L_MEANING
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
        AND LOOKUP_CODE = P_PRINT_DESCRIPTION;

Line: 943

        SELECT
          C_GL_CONV_RATE * AMOUNT
        INTO FC_AMOUNT
        FROM
          DUAL;

Line: 1032

      SELECT
        UNIT_OF_MEASURE
      INTO L_PERIODICITY
      FROM
        MTL_UNITS_OF_MEASURE_VL
      WHERE UOM_CODE = CHARGE_PERIODICITY_CODE
        AND UOM_CLASS = FND_PROFILE.VALUE('ONT_UOM_CLASS_CHARGE_PERIODICITY');

Line: 1109

      SELECT
        TRXN_EXTENSION_ID,
        TANGIBLE_ID
      FROM
        OE_PAYMENTS
      WHERE HEADER_ID = P_HEADER_ID
        AND NVL(PAYMENT_TYPE_CODE
         ,'COMMITMENT') = 'CREDIT_CARD';

Line: 1128

          SELECT
            AUTHORIZATION_AMOUNT
          INTO L_AUTHORIZED_AMOUNT
          FROM
            IBY_TRXN_EXT_AUTHS_V
          WHERE TRXN_EXTENSION_ID = L_TRXN_EXTENSION_ID
            AND AUTHORIZATION_STATUS = 0;

Line: 1137

            SELECT
              AMOUNT
            INTO L_AUTHORIZED_AMOUNT
            FROM
              IBY_TRXN_SUMMARIES_ALL
            WHERE TANGIBLEID = L_TANGIBLE_ID
              AND REQTYPE = 'ORAPMTREQ';

Line: 1211

      SELECT
        TRXN_EXTENSION_ID,
        TANGIBLE_ID
      FROM
        OE_PAYMENTS
      WHERE LINE_ID = P_LINE_ID
        AND NVL(PAYMENT_TYPE_CODE
         ,'COMMITMENT') = 'CREDIT_CARD';

Line: 1230

          SELECT
            AUTHORIZATION_AMOUNT
          INTO L_AUTHORIZED_AMOUNT
          FROM
            IBY_TRXN_EXT_AUTHS_V
          WHERE TRXN_EXTENSION_ID = L_TRXN_EXTENSION_ID
            AND AUTHORIZATION_STATUS = 0;

Line: 1239

            SELECT
              AMOUNT
            INTO L_AUTHORIZED_AMOUNT
            FROM
              IBY_TRXN_SUMMARIES_ALL
            WHERE TANGIBLEID = L_TANGIBLE_ID
              AND REQTYPE = 'ORAPMTREQ';

Line: 1266

      SELECT
        PARTY.PARTY_NAME
      INTO L_END_CUSTOMER
      FROM
        HZ_PARTIES PARTY,
        HZ_CUST_ACCOUNTS CUST_ACCT
      WHERE cust_acct.cust_account_id (+) = END_CUSTOMER_ID
        AND CUST_ACCT.PARTY_ID = party.party_id (+);

Line: 1287

      SELECT
        LOC.ADDRESS1
      INTO L_END_CUSTOMER_ADDRESS1
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1316

      SELECT
        LOC.CITY,
        NVL(LOC.STATE
           ,LOC.PROVINCE),
        LOC.POSTAL_CODE,
        LOC.COUNTRY
      INTO L_END_CUSTOMER_CITY,L_END_CUSTOMER_STATE,L_END_CUSTOMER_POSTAL_CODE,L_END_CUSTOMER_COUNTRY
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES SITE_USE,
        HZ_CUST_ACCT_SITES ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1332

      SELECT
        DECODE(L_END_CUSTOMER_CITY
              ,NULL
              ,NULL
              ,L_END_CUSTOMER_CITY || ', ') || DECODE(L_END_CUSTOMER_STATE
              ,NULL
              ,NULL
              ,L_END_CUSTOMER_STATE || ', ') || DECODE(L_END_CUSTOMER_POSTAL_CODE
              ,NULL
              ,NULL
              ,L_END_CUSTOMER_POSTAL_CODE || ',') || DECODE(L_END_CUSTOMER_COUNTRY
              ,NULL
              ,NULL
              ,L_END_CUSTOMER_COUNTRY)
      INTO L_END_CUSTOMER_ADDRESS5
      FROM
        DUAL;

Line: 1362

      SELECT
        NAME
      INTO L_END_CUSTOMER_CONTACT
      FROM
        OE_CONTACTS_V
      WHERE CONTACT_ID = END_CUSTOMER_CONTACT_ID;

Line: 1381

      SELECT
        LOC.COUNTRY
      INTO L_END_CUSTOMER_COUNTRY
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1406

      SELECT
        PARTY.PARTY_NUMBER
      INTO L_END_CUSTOMER
      FROM
        HZ_PARTIES PARTY,
        HZ_CUST_ACCOUNTS CUST_ACCT
      WHERE cust_acct.cust_account_id (+) = END_CUSTOMER_ID
        AND CUST_ACCT.PARTY_ID = party.party_id (+);

Line: 1436

      SELECT
        L.ADDRESS_LINE_1
      INTO L_ADDRESS1
      FROM
        OE_DELIVER_TO_ORGS_V L
      WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;

Line: 1444

      SELECT
        LOC.ADDRESS1
      INTO L_ADDRESS1
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = (
        SELECT
          SOLD_TO_SITE_USE_ID
        FROM
          OE_ORDER_HEADERS_ALL
        WHERE HEADER_ID = HEADER_ID )
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1463

      SELECT
        LOC.ADDRESS1
      INTO L_ADDRESS1
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1501

      SELECT
        L.TOWN_OR_CITY,
        L.STATE,
        L.POSTAL_CODE,
        L.COUNTRY
      INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
      FROM
        OE_DELIVER_TO_ORGS_V L
      WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;

Line: 1510

      SELECT
        DECODE(L_CITY
              ,NULL
              ,NULL
              ,L_CITY || ', ') || DECODE(L_STATE
              ,NULL
              ,NULL
              ,L_STATE || ', ') || DECODE(L_POSTAL_CODE
              ,NULL
              ,NULL
              ,L_POSTAL_CODE || ',') || DECODE(L_COUNTRY
              ,NULL
              ,NULL
              ,L_COUNTRY)
      INTO L_ADDRESS5
      FROM
        DUAL;

Line: 1529

      SELECT
        LOC.CITY,
        LOC.STATE,
        LOC.POSTAL_CODE,
        LOC.COUNTRY
      INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = (
        SELECT
          SOLD_TO_SITE_USE_ID
        FROM
          OE_ORDER_HEADERS_ALL
        WHERE HEADER_ID = HEADER_ID )
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1549

      SELECT
        DECODE(L_CITY
              ,NULL
              ,NULL
              ,L_CITY || ', ') || DECODE(L_STATE
              ,NULL
              ,NULL
              ,L_STATE || ', ') || DECODE(L_POSTAL_CODE
              ,NULL
              ,NULL
              ,L_POSTAL_CODE || ',') || DECODE(L_COUNTRY
              ,NULL
              ,NULL
              ,L_COUNTRY)
      INTO L_ADDRESS5
      FROM
        DUAL;

Line: 1568

      SELECT
        LOC.CITY,
        LOC.STATE,
        LOC.POSTAL_CODE,
        LOC.COUNTRY
      INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1583

      SELECT
        DECODE(L_CITY
              ,NULL
              ,NULL
              ,L_CITY || ', ') || DECODE(L_STATE
              ,NULL
              ,NULL
              ,L_STATE || ', ') || DECODE(L_POSTAL_CODE
              ,NULL
              ,NULL
              ,L_POSTAL_CODE || ',') || DECODE(L_COUNTRY
              ,NULL
              ,NULL
              ,L_COUNTRY)
      INTO L_ADDRESS5
      FROM
        DUAL;

Line: 1622

      SELECT
        L.ADDRESS_LINE_1
      INTO L_ADDRESS1
      FROM
        OE_DELIVER_TO_ORGS_V L
      WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;

Line: 1630

      SELECT
        LOC.ADDRESS1
      INTO L_ADDRESS1
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = (
        SELECT
          SOLD_TO_SITE_USE_ID
        FROM
          OE_ORDER_HEADERS_ALL
        WHERE HEADER_ID = HEADER_ID )
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1649

      SELECT
        LOC.ADDRESS1
      INTO L_ADDRESS1
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1687

      SELECT
        L.TOWN_OR_CITY,
        L.STATE,
        L.POSTAL_CODE,
        L.COUNTRY
      INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
      FROM
        OE_DELIVER_TO_ORGS_V L
      WHERE L.ORGANIZATION_ID = DELIVER_TO_ORG_ID;

Line: 1696

      SELECT
        DECODE(L_CITY
              ,NULL
              ,NULL
              ,L_CITY || ', ') || DECODE(L_STATE
              ,NULL
              ,NULL
              ,L_STATE || ', ') || DECODE(L_POSTAL_CODE
              ,NULL
              ,NULL
              ,L_POSTAL_CODE || ',') || DECODE(L_COUNTRY
              ,NULL
              ,NULL
              ,L_COUNTRY)
      INTO L_ADDRESS5
      FROM
        DUAL;

Line: 1715

      SELECT
        LOC.CITY,
        LOC.STATE,
        LOC.POSTAL_CODE,
        LOC.COUNTRY
      INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = (
        SELECT
          SOLD_TO_SITE_USE_ID
        FROM
          OE_ORDER_HEADERS_ALL
        WHERE HEADER_ID = HEADER_ID )
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1735

      SELECT
        DECODE(L_CITY
              ,NULL
              ,NULL
              ,L_CITY || ', ') || DECODE(L_STATE
              ,NULL
              ,NULL
              ,L_STATE || ', ') || DECODE(L_POSTAL_CODE
              ,NULL
              ,NULL
              ,L_POSTAL_CODE || ',') || DECODE(L_COUNTRY
              ,NULL
              ,NULL
              ,L_COUNTRY)
      INTO L_ADDRESS5
      FROM
        DUAL;

Line: 1754

      SELECT
        LOC.CITY,
        LOC.STATE,
        LOC.POSTAL_CODE,
        LOC.COUNTRY
      INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
      FROM
        HZ_LOCATIONS LOC,
        HZ_PARTY_SITES SITE,
        HZ_CUST_SITE_USES_ALL SITE_USE,
        HZ_CUST_ACCT_SITES_ALL ACCT_SITE
      WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
        AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
        AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
        AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line: 1769

      SELECT
        DECODE(L_CITY
              ,NULL
              ,NULL
              ,L_CITY || ', ') || DECODE(L_STATE
              ,NULL
              ,NULL
              ,L_STATE || ', ') || DECODE(L_POSTAL_CODE
              ,NULL
              ,NULL
              ,L_POSTAL_CODE || ',') || DECODE(L_COUNTRY
              ,NULL
              ,NULL
              ,L_COUNTRY)
      INTO L_ADDRESS5
      FROM
        DUAL;

Line: 1802

      SELECT
        SOLD_TO
      INTO L_SOLD_TO
      FROM
        OE_ORDER_HEADERS_V H
      WHERE H.HEADER_ID = HEADER_ID;

Line: 1810

      SELECT
        PARTY.PARTY_NAME
      INTO L_END_CUSTOMER
      FROM
        HZ_PARTIES PARTY,
        HZ_CUST_ACCOUNTS CUST_ACCT
      WHERE cust_acct.cust_account_id (+) = END_CUSTOMER_ID
        AND CUST_ACCT.PARTY_ID = party.party_id (+);

Line: 1830

    SELECT
      MEANING
    INTO PA_END_DISPLAY
    FROM
      OE_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = P_END_CUST;

Line: 2083

    select sitems.concatenated_segments item,
    	   sitems.description description
    into   v_item,v_description
    from   mtl_system_items_vl sitems
    where    nvl(sitems.organization_id,0) = C_MASTER_ORG
    and    sitems.inventory_item_id = INVENTORY_ITEM_ID_T;

Line: 2102

    select citems.customer_item_number item,
    	   nvl(citems.customer_item_desc,sitems.description) description
    into   v_item,v_description
    from   mtl_customer_items citems,
           mtl_customer_item_xrefs cxref,
           mtl_system_items_vl sitems
    where  citems.customer_item_id = cxref.customer_item_id
    and    cxref.inventory_item_id = sitems.inventory_item_id
    and    citems.customer_item_id = ORDERED_ITEM_ID_T
    and    nvl(sitems.organization_id,0) = C_MASTER_ORG
    and    sitems.inventory_item_id = INVENTORY_ITEM_ID_T;

Line: 2115

    select items.cross_reference item,
    	   nvl(items.description,sitems.description) description
    into   v_item,v_description
    from   mtl_cross_reference_types xtypes,
           mtl_cross_references items,
           mtl_system_items_vl sitems
    where  xtypes.cross_reference_type = items.cross_reference_type
    and    items.inventory_item_id = sitems.inventory_item_id
    and    items.cross_reference = ORDERED_ITEM
    and    items.cross_reference_type = ITEM_IDENTIFIER_TYPE
    and    nvl(sitems.organization_id,0) = C_MASTER_ORG
    and    sitems.inventory_item_id = INVENTORY_ITEM_ID_T
    --Bug 3433353 Begin
    and items.org_independent_flag = 'N'
    and  items.organization_id = C_MASTER_ORG;

Line: 2131

    select items.cross_reference item,
    nvl(items.description,sitems.description) description
    into v_item, v_description
    from mtl_cross_reference_types xtypes,
    mtl_cross_references items,
    mtl_system_items_vl sitems
    where xtypes.cross_reference_type =
    items.cross_reference_type
    and items.inventory_item_id = sitems.inventory_item_id
    and items.cross_reference = ORDERED_ITEM
    and items.cross_reference_type = ITEM_IDENTIFIER_TYPE
    and nvl(sitems.organization_id,0) = C_MASTER_ORG
    and sitems.inventory_item_id = INVENTORY_ITEM_ID_T
    and items.org_independent_flag = 'Y';