[Home] [Help]
View: PJM_PROJECT_ONHAND_V
Product: | PJM - Project Manufacturing |
Description: | Project inventory onhand quantities for the Web Inquiry. |
Implementation/DBA Data: |
APPS.PJM_PROJECT_ONHAND_V
|
View Text
SELECT LOC.PROJECT_ID
, LOC.TASK_ID
, QTY.ORGANIZATION_ID
, ORG.NAME
, QTY.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, ITEM.DESCRIPTION
, QTY.SUBINVENTORY_CODE
, PHYLOC.CONCATENATED_SEGMENTS
, PRIMARY_UOM_CODE
, NVL( SUM( QTY.TRANSACTION_QUANTITY )
, 0 )
FROM MTL_ONHAND_QUANTITIES_DETAIL QTY
, MTL_ITEM_LOCATIONS LOC
, MTL_SYSTEM_ITEMS_KFV ITEM
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, MTL_ITEM_LOCATIONS_KFV PHYLOC
WHERE LOC.ORGANIZATION_ID = QTY.ORGANIZATION_ID
AND LOC.INVENTORY_LOCATION_ID = QTY.LOCATOR_ID
AND ITEM.INVENTORY_ITEM_ID = QTY.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = QTY.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = QTY.ORGANIZATION_ID
AND ORG.LANGUAGE = USERENV('LANG')
AND PHYLOC.ORGANIZATION_ID = LOC.ORGANIZATION_ID
AND PHYLOC.INVENTORY_LOCATION_ID = NVL( LOC.PHYSICAL_LOCATION_ID
, LOC.INVENTORY_LOCATION_ID ) GROUP BY LOC.PROJECT_ID
, LOC.TASK_ID
, QTY.ORGANIZATION_ID
, ORG.NAME
, QTY.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, ITEM.DESCRIPTION
, QTY.SUBINVENTORY_CODE
, PHYLOC.CONCATENATED_SEGMENTS
, PRIMARY_UOM_CODE
Columns
Name |
PROJECT_ID |
TASK_ID |
ORGANIZATION_ID |
ORGANIZATION_NAME |
INVENTORY_ITEM_ID |
ITEM |
ITEM_DESCRIPTION |
SUBINVENTORY |
LOCATOR |
PRIMARY_UOM |
TOTAL_ONHAND_QUANTITY |