VIEW: APPS.WSM_START_JOB_SERIAL_NUMS_V

Source

View Text - Preformatted

SELECT WST.serial_number , WSMT.transaction_id , WST.current_wip_entity_name , WST.current_wip_entity_id , msn.SERIAL_ATTRIBUTE_CATEGORY , msn.TERRITORY_CODE , msn.ORIGINATION_DATE , MSN.C_ATTRIBUTE1 , MSN.C_ATTRIBUTE2 , MSN.C_ATTRIBUTE3 , MSN.C_ATTRIBUTE4 , MSN.C_ATTRIBUTE5 , MSN.C_ATTRIBUTE6 , MSN.C_ATTRIBUTE7 , MSN.C_ATTRIBUTE8 , MSN.C_ATTRIBUTE9 , MSN.C_ATTRIBUTE10 , MSN.C_ATTRIBUTE11 , MSN.C_ATTRIBUTE12 , MSN.C_ATTRIBUTE13 , MSN.C_ATTRIBUTE14 , MSN.C_ATTRIBUTE15 , MSN.C_ATTRIBUTE16 , MSN.C_ATTRIBUTE17 , MSN.C_ATTRIBUTE18 , MSN.C_ATTRIBUTE19 , MSN.C_ATTRIBUTE20 , MSN.D_ATTRIBUTE1 , MSN.D_ATTRIBUTE2 , MSN.D_ATTRIBUTE3 , MSN.D_ATTRIBUTE4 , MSN.D_ATTRIBUTE5 , MSN.D_ATTRIBUTE6 , MSN.D_ATTRIBUTE7 , MSN.D_ATTRIBUTE8 , MSN.D_ATTRIBUTE9 , MSN.D_ATTRIBUTE10 , MSN.N_ATTRIBUTE1 , MSN.N_ATTRIBUTE2 , MSN.N_ATTRIBUTE3 , MSN.N_ATTRIBUTE4 , MSN.N_ATTRIBUTE5 , MSN.N_ATTRIBUTE6 , MSN.N_ATTRIBUTE7 , MSN.N_ATTRIBUTE8 , MSN.N_ATTRIBUTE9 , MSN.N_ATTRIBUTE10 , MSN.STATUS_ID , MSN.TIME_SINCE_NEW , MSN.CYCLES_SINCE_NEW , MSN.TIME_SINCE_OVERHAUL , MSN.CYCLES_SINCE_OVERHAUL , MSN.TIME_SINCE_REPAIR , MSN.CYCLES_SINCE_REPAIR , MSN.TIME_SINCE_VISIT , MSN.CYCLES_SINCE_VISIT , MSN.TIME_SINCE_MARK , MSN.CYCLES_SINCE_MARK , MSN.NUMBER_OF_REPAIRS , MSN.ATTRIBUTE_CATEGORY , MSN.ATTRIBUTE1 , MSN.ATTRIBUTE2 , MSN.ATTRIBUTE3 , MSN.ATTRIBUTE4 , MSN.ATTRIBUTE5 , MSN.ATTRIBUTE6 , MSN.ATTRIBUTE7 , MSN.ATTRIBUTE8 , MSN.ATTRIBUTE9 , MSN.ATTRIBUTE10 , MSN.ATTRIBUTE11 , MSN.ATTRIBUTE12 , MSN.ATTRIBUTE13 , MSN.ATTRIBUTE14 , MSN.ATTRIBUTE15 from WSM_SERIAL_TRANSACTIONS WST , MTL_SERIAL_NUMBERS MSN , WSM_SPLIT_MERGE_TRANSACTIONS WSMT , WSM_SM_STARTING_JOBS WSSJ WHERE WSMT.TRANSACTION_ID = WST.transaction_id and WST.gen_object_id = MSN.gen_object_id and WSMT.transaction_id = WSSJ.transaction_id and WST.transaction_type_id = 3 and WST.current_wip_entity_id = WSSJ.wip_entity_id and WST.current_wip_entity_name = WSSJ.wip_entity_name

View Text - HTML Formatted

SELECT WST.SERIAL_NUMBER
, WSMT.TRANSACTION_ID
, WST.CURRENT_WIP_ENTITY_NAME
, WST.CURRENT_WIP_ENTITY_ID
, MSN.SERIAL_ATTRIBUTE_CATEGORY
, MSN.TERRITORY_CODE
, MSN.ORIGINATION_DATE
, MSN.C_ATTRIBUTE1
, MSN.C_ATTRIBUTE2
, MSN.C_ATTRIBUTE3
, MSN.C_ATTRIBUTE4
, MSN.C_ATTRIBUTE5
, MSN.C_ATTRIBUTE6
, MSN.C_ATTRIBUTE7
, MSN.C_ATTRIBUTE8
, MSN.C_ATTRIBUTE9
, MSN.C_ATTRIBUTE10
, MSN.C_ATTRIBUTE11
, MSN.C_ATTRIBUTE12
, MSN.C_ATTRIBUTE13
, MSN.C_ATTRIBUTE14
, MSN.C_ATTRIBUTE15
, MSN.C_ATTRIBUTE16
, MSN.C_ATTRIBUTE17
, MSN.C_ATTRIBUTE18
, MSN.C_ATTRIBUTE19
, MSN.C_ATTRIBUTE20
, MSN.D_ATTRIBUTE1
, MSN.D_ATTRIBUTE2
, MSN.D_ATTRIBUTE3
, MSN.D_ATTRIBUTE4
, MSN.D_ATTRIBUTE5
, MSN.D_ATTRIBUTE6
, MSN.D_ATTRIBUTE7
, MSN.D_ATTRIBUTE8
, MSN.D_ATTRIBUTE9
, MSN.D_ATTRIBUTE10
, MSN.N_ATTRIBUTE1
, MSN.N_ATTRIBUTE2
, MSN.N_ATTRIBUTE3
, MSN.N_ATTRIBUTE4
, MSN.N_ATTRIBUTE5
, MSN.N_ATTRIBUTE6
, MSN.N_ATTRIBUTE7
, MSN.N_ATTRIBUTE8
, MSN.N_ATTRIBUTE9
, MSN.N_ATTRIBUTE10
, MSN.STATUS_ID
, MSN.TIME_SINCE_NEW
, MSN.CYCLES_SINCE_NEW
, MSN.TIME_SINCE_OVERHAUL
, MSN.CYCLES_SINCE_OVERHAUL
, MSN.TIME_SINCE_REPAIR
, MSN.CYCLES_SINCE_REPAIR
, MSN.TIME_SINCE_VISIT
, MSN.CYCLES_SINCE_VISIT
, MSN.TIME_SINCE_MARK
, MSN.CYCLES_SINCE_MARK
, MSN.NUMBER_OF_REPAIRS
, MSN.ATTRIBUTE_CATEGORY
, MSN.ATTRIBUTE1
, MSN.ATTRIBUTE2
, MSN.ATTRIBUTE3
, MSN.ATTRIBUTE4
, MSN.ATTRIBUTE5
, MSN.ATTRIBUTE6
, MSN.ATTRIBUTE7
, MSN.ATTRIBUTE8
, MSN.ATTRIBUTE9
, MSN.ATTRIBUTE10
, MSN.ATTRIBUTE11
, MSN.ATTRIBUTE12
, MSN.ATTRIBUTE13
, MSN.ATTRIBUTE14
, MSN.ATTRIBUTE15
FROM WSM_SERIAL_TRANSACTIONS WST
, MTL_SERIAL_NUMBERS MSN
, WSM_SPLIT_MERGE_TRANSACTIONS WSMT
, WSM_SM_STARTING_JOBS WSSJ
WHERE WSMT.TRANSACTION_ID = WST.TRANSACTION_ID
AND WST.GEN_OBJECT_ID = MSN.GEN_OBJECT_ID
AND WSMT.TRANSACTION_ID = WSSJ.TRANSACTION_ID
AND WST.TRANSACTION_TYPE_ID = 3
AND WST.CURRENT_WIP_ENTITY_ID = WSSJ.WIP_ENTITY_ID
AND WST.CURRENT_WIP_ENTITY_NAME = WSSJ.WIP_ENTITY_NAME