VIEW: APPS.GMD_QM_E_MATERIAL_SOURCES_V

Source

View Text - Preformatted

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_b c, gmd_ss_storage_package d, gmd_ss_variants h, gmd_specifications_b i, gmd_specifications_b s, fm_form_mst_b j,mtl_item_locations_kfv k, mtl_parameters 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

View Text - HTML Formatted

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_B C
, GMD_SS_STORAGE_PACKAGE D
, GMD_SS_VARIANTS H
, GMD_SPECIFICATIONS_B I
, GMD_SPECIFICATIONS_B S
, FM_FORM_MST_B J
, MTL_ITEM_LOCATIONS_KFV K
, MTL_PARAMETERS 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