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: 54

    SELECT
      NAME
    INTO SOB_NAME
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = P_SOB_ID;

Line: 72

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

Line: 90

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

Line: 108

      SELECT
        CURRENCY_CODE
      INTO BASE_CURRENCY
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = P_SOB_ID;

Line: 127

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

Line: 147

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

Line: 167

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

Line: 223

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

Line: 260

        SELECT
          C_GL_CONV_RATE * HDR_PA_AMOUNT
        INTO FC_PA_AMOUNT
        FROM
          DUAL;

Line: 281

        SELECT
          C_GL_CONV_RATE * LIST_PRICE
        INTO FC_LIST_PRICE
        FROM
          DUAL;

Line: 317

        SELECT
          C_GL_CONV_RATE * SELLING_PRICE
        INTO FC_SELLING_PRICE
        FROM
          DUAL;

Line: 353

        SELECT
          C_GL_CONV_RATE * EXTENDED_PRICE
        INTO FC_EXTENDED_PRICE
        FROM
          DUAL;

Line: 388

        SELECT
          C_GL_CONV_RATE * L_PA_AMOUNT
        INTO FC_PA_AMOUNT
        FROM
          DUAL;

Line: 449

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

Line: 520

        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: 527

        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: 537

          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: 547

            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: 574

        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: 581

        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: 591

          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: 601

            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: 705

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

Line: 726

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

Line: 858

        SELECT
          C_GL_CONV_RATE * SVC_EXTENDED_PRICE
        INTO FC_SVC_EXTENDED_PRICE
        FROM
          DUAL;

Line: 878

        SELECT
          C_GL_CONV_RATE * SVC_SELLING_PRICE
        INTO FC_SVC_SELLING_PRICE
        FROM
          DUAL;

Line: 901

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

Line: 921

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

Line: 947

        SELECT
          C_GL_CONV_RATE * AMOUNT
        INTO FC_AMOUNT
        FROM
          DUAL;

Line: 1036

      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: 1113

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

Line: 1132

          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: 1141

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

Line: 1215

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

Line: 1234

          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: 1243

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

Line: 1270

      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: 1291

      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: 1320

      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: 1336

      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: 1366

      SELECT
        NAME
      INTO L_END_CUSTOMER_CONTACT
      FROM
        OE_CONTACTS_V
      WHERE CONTACT_ID = END_CUSTOMER_CONTACT_ID;

Line: 1385

      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: 1410

      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: 1440

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

Line: 1448

      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: 1467

      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: 1505

      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: 1514

      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: 1533

      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: 1553

      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: 1572

      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: 1587

      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: 1626

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

Line: 1634

      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: 1653

      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: 1691

      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: 1700

      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: 1719

      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: 1739

      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: 1758

      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: 1773

      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: 1806

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

Line: 1814

      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: 1834

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

Line: 2087

    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: 2106

    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: 2119

    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: 2135

    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';