Scribd Logo
Upload

Welcome to Scribd!

  • 47 views

    Sub Inventories

    Uploaded by

    Ahmed
    This SQL query selects distinct organization codes, secondary inventory names, descriptions, disable dates, asset inventories, and quantity tracked from the INV_ORG_PARAMETERS and INV_SECONDARY_INVENTORIES tables, joining them on the organization ID field.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Sub Inventories

    Uploaded by

    Ahmed
    47 views1 page
    This SQL query selects distinct organization codes, secondary inventory names, descriptions, disable dates, asset inventories, and quantity tracked from the INV_ORG_PARAMETERS and INV_SECONDARY_INVENTORIES tables, joining them on the organization ID field.

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This SQL query selects distinct organization codes, secondary inventory names, descriptions, disable dates, asset inventories, and quantity tracked from the INV_ORG_PARAMETERS and INV_SECONDARY_INVENTORIES tables, joining them on the organization ID field.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    47 views1 page

    Sub Inventories

    Uploaded by

    Ahmed
    This SQL query selects distinct organization codes, secondary inventory names, descriptions, disable dates, asset inventories, and quantity tracked from the INV_ORG_PARAMETERS and INV_SECONDARY_INVENTORIES tables, joining them on the organization ID field.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    of 1

    select DISTINCT

    ORG.ORGANIZATION_CODE,
    sub.SECONDARY_INVENTORY_NAME,
    sub.DESCRIPTION,
    sub.DISABLE_DATE,
    sub.ASSET_INVENTORY,
    sub.QUANTITY_TRACKED

    FROM
    INV_ORG_PARAMETERS ORG,
    INV_SECONDARY_INVENTORIES sub

    WHERE
    org.ORGANIZATION_ID = sub.ORGANIZATION_ID

    You might also like