View: GMD_QM_E_MATERIAL_SOURCES_V

Product:	GMD - Process Manufacturing Product Development
Description:
Implementation/DBA Data:	APPS.GMD_QM_E_MATERIAL_SOURCES_V

View Text

SELECT L.ORGANIZATION_CODE
, A.SS_ID
, B.BATCH_NO
, A.RECIPE_NO
, C.RECIPE_VERSION
, A.LOT_NUMBER
, D.QUANTITY
, D.QUANTITY_UOM
, H.VARIANT_ID
, H.VARIANT_NO
, H.MATERIAL_SOURCE_ID
, L.ORGANIZATION_CODE
, H.STORAGE_SUBINVENTORY
, K.CONCATENATED_SEGMENTS
, I.SPEC_ID STORAGE_SPEC_ID
, I.SPEC_NAME STORGE_SPEC_NAME
, I.SPEC_VERS STORAGE_SPEC_VERSION
, S.SPEC_ID DEFAULT_SPEC_ID
, S.SPEC_NAME DEFAULT_SPEC_NAME
, S.SPEC_VERS DEFAULT_SPEC_VERSION
, H.SCHEDULED_START_DATE VARIANT_SCHED_START_DATE
, H.SAMPLING_EVENT_ID
, H.SAMPLE_QTY
, H.SAMPLE_QUANTITY_UOM
, H.SAMPLES_PER_TIME_POINT SAMPLES_PER_TP
, H.RETAINED_SAMPLES
, RESOURCES
, RESOURCE_INSTANCE_ID
, YIELD_DATE
, J.FORMULA_NO
, J.FORMULA_VERS
, D.PACKAGE_NAME
FROM GMD_SS_MATERIAL_SOURCES A
, GME_BATCH_HEADER B
, GMD_RECIPES C
, GMD_SS_STORAGE_PACKAGE D
, GMD_SS_VARIANTS H
, GMD_SPECIFICATIONS I
, GMD_SPECIFICATIONS S
, FM_FORM_MST J
, MTL_ITEM_LOCATIONS_KFV K
, MTL_ORGANIZATIONS L
WHERE A.RECIPE_ID = C.RECIPE_ID(+)
AND A.BATCH_ID = B.BATCH_ID(+)
AND H.MATERIAL_SOURCE_ID = A.SOURCE_ID
AND H.STORAGE_SPEC_ID = I.SPEC_ID
AND H.DEFAULT_SPEC_ID = S.SPEC_ID
AND H.PACKAGE_ID = D.PACKAGE_ID(+)
AND D.FORMULA_ID = J.FORMULA_ID(+)
AND K.INVENTORY_LOCATION_ID(+) = H.STORAGE_LOCATOR_ID
AND L.ORGANIZATION_ID = A.SOURCE_ORGANIZATION_ID
AND L.ORGANIZATION_ID =H.STORAGE_ORGANIZATION_ID

Columns