Saturday, 26 September 2015

Item with categories query -- Oracle Apps

SELECT DISTINCT MSIB.ORGANIZATION_ID,OOD.ORGANIZATION_NAME,IGC.SEGMENT6 PRODUCT_CODE,IGC.SEG6_DESC PRODUCT ,MSIB.SEGMENT1 ITEM_CODE,MSIB.DESCRIPTION,MC.SEGMENT1 MAJOR_CATEGORY,MC.SEGMENT2 MINOR_CATEGORY
FROM
GL_CODE_COMBINATIONS IGC,
MTL_SYSTEM_ITEMS_B MSIB,
MTL_ITEM_CATEGORIES MIC,
MTL_CATEGORIES MC,
ORG_ORGANIZATION_DEFINITIONS OOD
WHERE
IGC.CODE_COMBINATION_ID = MSIB.SALES_ACCOUNT
AND MSIB.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MIC.CATEGORY_ID = MC.CATEGORY_ID
AND MSIB.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND MSIB.ORGANIZATION_ID = 10

No comments:

Post a Comment