VIEW: APPS.WSM_INV_TXNS_WIP_LOTS_V

Source

View Text - Preformatted

SELECT we.gen_object_id object_id, 5 object_type, mmt.organization_id organization_id, mmt.transaction_id transaction_id, mmt.transaction_date transaction_date, mp.organization_code organization_code, mtst.transaction_source_type_name transaction_source_type_name, DECODE(mmt.transaction_source_type_id,13,mmt.transaction_source_name, Inv_Object_Genealogy.getSource(mmt.organization_id, mmt.transaction_source_type_id, mmt.transaction_source_id)) transaction_source, null trading_partner, null project, null task, mmt.transaction_quantity transaction_quantity, mmt.transaction_uom, mmt.primary_quantity primary_quantity, mmt.created_by, mmt.source_code, mmt.source_line_id, mmt.transaction_type_id, wlpn1.license_plate_number lpn_number, wlpn2.license_plate_number transfer_lpn_number, wlpn3.license_plate_number content_lpn_number, mmt.locator_id, mmt.subinventory_code, mmt.vendor_lot_number supplier_lot_number, NULL transaction_lot_number, NULL secondary_quantity, NULL grade_code FROM wip_entities we, mtl_material_transactions mmt, mtl_txn_source_types mtst, mtl_parameters mp, wms_license_plate_numbers wlpn1, wms_license_plate_numbers wlpn2, wms_license_plate_numbers wlpn3 where mmt.transaction_source_id=we.wip_entity_id AND mmt.transaction_source_type_id = mtst.transaction_source_type_id AND mmt.transaction_action_id in (1, 27,30, 31, 32,33,34 ) AND mmt.transaction_source_type_id = 5 AND mmt.organization_id = mp.organization_id AND wlpn1.lpn_id(+) = mmt.lpn_id AND wlpn2.lpn_id(+) = mmt.transfer_lpn_id AND wlpn3.lpn_id(+) = mmt.content_lpn_id

View Text - HTML Formatted

SELECT WE.GEN_OBJECT_ID OBJECT_ID
, 5 OBJECT_TYPE
, MMT.ORGANIZATION_ID ORGANIZATION_ID
, MMT.TRANSACTION_ID TRANSACTION_ID
, MMT.TRANSACTION_DATE TRANSACTION_DATE
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, MTST.TRANSACTION_SOURCE_TYPE_NAME TRANSACTION_SOURCE_TYPE_NAME
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 13
, MMT.TRANSACTION_SOURCE_NAME
, INV_OBJECT_GENEALOGY.GETSOURCE(MMT.ORGANIZATION_ID
, MMT.TRANSACTION_SOURCE_TYPE_ID
, MMT.TRANSACTION_SOURCE_ID)) TRANSACTION_SOURCE
, NULL TRADING_PARTNER
, NULL PROJECT
, NULL TASK
, MMT.TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, MMT.TRANSACTION_UOM
, MMT.PRIMARY_QUANTITY PRIMARY_QUANTITY
, MMT.CREATED_BY
, MMT.SOURCE_CODE
, MMT.SOURCE_LINE_ID
, MMT.TRANSACTION_TYPE_ID
, WLPN1.LICENSE_PLATE_NUMBER LPN_NUMBER
, WLPN2.LICENSE_PLATE_NUMBER TRANSFER_LPN_NUMBER
, WLPN3.LICENSE_PLATE_NUMBER CONTENT_LPN_NUMBER
, MMT.LOCATOR_ID
, MMT.SUBINVENTORY_CODE
, MMT.VENDOR_LOT_NUMBER SUPPLIER_LOT_NUMBER
, NULL TRANSACTION_LOT_NUMBER
, NULL SECONDARY_QUANTITY
, NULL GRADE_CODE
FROM WIP_ENTITIES WE
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TXN_SOURCE_TYPES MTST
, MTL_PARAMETERS MP
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WMS_LICENSE_PLATE_NUMBERS WLPN2
, WMS_LICENSE_PLATE_NUMBERS WLPN3
WHERE MMT.TRANSACTION_SOURCE_ID=WE.WIP_ENTITY_ID
AND MMT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
AND MMT.TRANSACTION_ACTION_ID IN (1
, 27
, 30
, 31
, 32
, 33
, 34 )
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
AND MMT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WLPN1.LPN_ID(+) = MMT.LPN_ID
AND WLPN2.LPN_ID(+) = MMT.TRANSFER_LPN_ID
AND WLPN3.LPN_ID(+) = MMT.CONTENT_LPN_ID