The following lines contain the word 'select', 'insert', 'update' or 'delete':
select entity_type
into l_job_type
from wip_entities WE
where WE.wip_entity_id = p_wipEntityID
and WE.organization_id = p_orgID;
l_msg_tokens.delete;
l_msg_tokens.delete;
SELECT TRANSACTION_ID
FROM MTL_MATERIAL_TRANSACTIONS MMT
WHERE MMT.organization_id = p_organization_id
AND MMT.move_transaction_id IN (l_move_txn_id,l_scrap_txn_id)
AND MMT.transaction_source_id = p_wip_entity_id
AND MMT.subinventory_code IS NOT NULL
AND MMT.transaction_type_id IN (WIP_CONSTANTS.ISSCOMP_TYPE, -- 35 -- WIP Component Issue
WIP_CONSTANTS.ISSNEGC_TYPE -- 38 -- Negative component issue
);
SELECT TRANSACTION_ID,
SERIAL_TRANSACTION_ID,
LOT_NUMBER,
ROWID
from mtl_transaction_lot_numbers MTLN
where MTLN.organization_id = p_organization_id
and MTLN.transaction_id = v_txn_id;
l_param_tbl.delete;
l_msg_tokens.delete;
/*SELECT mtl_material_transactions_s.nextval
into p_mtl_txn_hdr_id
from dual;
SELECT mtl_material_transactions_s.nextval
into p_compl_txn_id
from dual;
select max(wmt.transaction_id)
into l_move_txn_id
from wip_move_transactions wmt
where wmt.organization_id = p_organization_id
and wmt.wip_entity_id = p_wip_entity_id
and wmt.wsm_undo_txn_id IS NULL
and wmt.transaction_id = nvl(wmt.batch_id,wmt.transaction_id)
and wmt.transaction_id <> p_move_txn_id;
select wmt.transaction_id
into l_scrap_txn_id
from wip_move_transactions wmt
where wmt.organization_id = p_organization_id
and wmt.wip_entity_id = p_wip_entity_id
and wmt.wsm_undo_txn_id IS NULL
and wmt.transaction_id <> p_move_txn_id
and wmt.transaction_id <> wmt.batch_id
and wmt.batch_id = l_move_txn_id;
l_msg_tokens.delete;
select mtl_material_transactions_s.nextval
into l_temp_id
from dual;
l_msg_tokens.delete;
INSERT INTO mtl_material_transactions_temp
(
TRANSACTION_HEADER_ID,
TRANSACTION_TEMP_ID,
SOURCE_CODE,
SOURCE_LINE_ID,
PROCESS_FLAG,
POSTING_FLAG,
--WIP_COMMIT_FLAG,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
PROGRAM_APPLICATION_ID,
REQUEST_ID,
ORGANIZATION_ID,
SUBINVENTORY_CODE,
LOCATOR_ID,
INVENTORY_ITEM_ID,
REVISION,
TRANSACTION_TYPE_ID,
TRANSACTION_ACTION_ID,
TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_SOURCE_ID,
TRANSACTION_SOURCE_NAME,
TRANSACTION_REFERENCE,
REASON_ID,
TRANSACTION_DATE,
ACCT_PERIOD_ID,
TRANSACTION_QUANTITY,
TRANSACTION_UOM,
PRIMARY_QUANTITY,
OPERATION_SEQ_NUM,
DEPARTMENT_ID,
EMPLOYEE_CODE,
WIP_ENTITY_TYPE,
COMPLETION_TRANSACTION_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
MOVEMENT_ID,
SOURCE_PROJECT_ID,
SOURCE_TASK_ID,
PROJECT_ID,
TASK_ID,
MOVE_TRANSACTION_ID --Bug 5207917
)
SELECT
p_mtl_txn_hdr_id,
l_temp_id,
MMT.SOURCE_CODE,
MMT.SOURCE_LINE_ID,
'Y', -- PROCESS_FLAG,
'Y',-- POSTING_FLAG,
--'N',-- WIP_COMMIT_FLAG,
sysdate,
l_user_id,
sysdate,
l_user_id,
l_login_id,
l_prog_id,
sysdate,
l_prog_appl_id,
l_req_id,
MMT.ORGANIZATION_ID,
MMT.SUBINVENTORY_CODE,
MMT.LOCATOR_ID,
MMT.INVENTORY_ITEM_ID,
MMT.REVISION,
decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,
wip_constants.retnegc_type,
wip_constants.retcomp_type
),
decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,
wip_constants.retnegc_action,
wip_constants.retcomp_action
),
MMT.TRANSACTION_SOURCE_TYPE_ID,
MMT.TRANSACTION_SOURCE_ID,
MMT.TRANSACTION_SOURCE_NAME,
MMT.TRANSACTION_REFERENCE,
MMT.REASON_ID,
p_txn_date, -- transaction date
l_acct_period_id, -- accout period id...
-1 * MMT.TRANSACTION_QUANTITY,
MMT.TRANSACTION_UOM,
-1 * MMT.PRIMARY_QUANTITY,
MMT.OPERATION_SEQ_NUM,
MMT.DEPARTMENT_ID,
MMT.EMPLOYEE_CODE,
5, --MMT.WIP_ENTITY_TYPE,
p_compl_txn_id,
MMT.ATTRIBUTE_CATEGORY,
MMT.ATTRIBUTE1,
MMT.ATTRIBUTE2,
MMT.ATTRIBUTE3,
MMT.ATTRIBUTE4,
MMT.ATTRIBUTE5,
MMT.ATTRIBUTE6,
MMT.ATTRIBUTE7,
MMT.ATTRIBUTE8,
MMT.ATTRIBUTE9,
MMT.ATTRIBUTE10,
MMT.ATTRIBUTE11,
MMT.ATTRIBUTE12,
MMT.ATTRIBUTE13,
MMT.ATTRIBUTE14,
MMT.ATTRIBUTE15,
MMT.MOVEMENT_ID,
MMT.SOURCE_PROJECT_ID,
MMT.SOURCE_TASK_ID,
MMT.PROJECT_ID,
MMT.TASK_ID,
p_move_txn_id --Bug 5207917
FROM MTL_MATERIAL_TRANSACTIONS MMT
WHERE TRANSACTION_ID = l_mmt_rec.transaction_id;
l_msg_tokens.delete;
p_msg_text => 'Inserted : ' || SQL%ROWCOUNT || ' rows into MMTT',
p_stmt_num => l_stmt_num ,
p_msg_tokens => l_msg_tokens ,
p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
p_run_log_level => l_log_level
);
select mtl_material_transactions_s.nextval
into l_serial_txn_id
from dual;
insert into mtl_transaction_lots_temp
(
TRANSACTION_TEMP_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
TRANSACTION_QUANTITY ,
PRIMARY_QUANTITY ,
LOT_NUMBER ,
SERIAL_TRANSACTION_TEMP_ID ,
DESCRIPTION ,
VENDOR_NAME ,
SUPPLIER_LOT_NUMBER ,
ORIGINATION_DATE ,
DATE_CODE ,
GRADE_CODE ,
CHANGE_DATE ,
MATURITY_DATE ,
STATUS_ID ,
RETEST_DATE ,
AGE ,
ITEM_SIZE ,
COLOR ,
VOLUME ,
VOLUME_UOM ,
PLACE_OF_ORIGIN ,
BEST_BY_DATE ,
LENGTH ,
LENGTH_UOM ,
RECYCLED_CONTENT ,
THICKNESS ,
THICKNESS_UOM ,
WIDTH ,
WIDTH_UOM ,
CURL_WRINKLE_FOLD ,
LOT_ATTRIBUTE_CATEGORY ,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
VENDOR_ID ,
TERRITORY_CODE ,
PRODUCT_CODE ,
PRODUCT_TRANSACTION_ID ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15 --,
)
SELECT
l_temp_id ,
sysdate ,
l_user_id ,
sysdate ,
l_user_id ,
l_login_id ,
l_req_id ,
l_prog_appl_id ,
l_prog_id ,
sysdate ,
-1 * TRANSACTION_QUANTITY ,
-1 * PRIMARY_QUANTITY ,
LOT_NUMBER ,
l_serial_txn_id ,
DESCRIPTION ,
VENDOR_NAME ,
SUPPLIER_LOT_NUMBER ,
ORIGINATION_DATE ,
DATE_CODE ,
GRADE_CODE ,
CHANGE_DATE ,
MATURITY_DATE ,
STATUS_ID ,
RETEST_DATE ,
AGE ,
ITEM_SIZE ,
COLOR ,
VOLUME ,
VOLUME_UOM ,
PLACE_OF_ORIGIN ,
BEST_BY_DATE ,
LENGTH ,
LENGTH_UOM ,
RECYCLED_CONTENT ,
THICKNESS ,
THICKNESS_UOM ,
WIDTH ,
WIDTH_UOM ,
CURL_WRINKLE_FOLD ,
LOT_ATTRIBUTE_CATEGORY ,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
VENDOR_ID ,
TERRITORY_CODE ,
PRODUCT_CODE ,
PRODUCT_TRANSACTION_ID ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15 --,
--PARENT_LOT_NUMBER
from MTL_TRANSACTION_LOT_NUMBERS
--Bug 5614015:Rowid is used to uniquely identify the lot selected
--where transaction_id = l_mmt_rec.transaction_id
--and lot_number = l_lot_txn_rec.lot_number;
l_msg_tokens.delete;
p_msg_text => 'Inserted : ' || SQL%ROWCOUNT
|| ' rows into MTLT for lot '
|| l_lot_txn_rec.lot_number,
p_stmt_num => l_stmt_num ,
p_msg_tokens => l_msg_tokens ,
p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
p_run_log_level => l_log_level
);
insert into mtl_serial_numbers_temp
(
TRANSACTION_TEMP_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
--VENDOR_SERIAL_NUMBER ,
--VENDOR_LOT_NUMBER ,
FM_SERIAL_NUMBER ,
TO_SERIAL_NUMBER ,
--SERIAL_PREFIX ,
--ERROR_CODE ,
--GROUP_HEADER_ID ,
PARENT_SERIAL_NUMBER ,
SERIAL_ATTRIBUTE_CATEGORY ,
ORIGINATION_DATE ,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
STATUS_ID ,
TERRITORY_CODE ,
TIME_SINCE_NEW ,
CYCLES_SINCE_NEW ,
TIME_SINCE_OVERHAUL ,
CYCLES_SINCE_OVERHAUL ,
TIME_SINCE_REPAIR ,
CYCLES_SINCE_REPAIR ,
TIME_SINCE_VISIT ,
CYCLES_SINCE_VISIT ,
TIME_SINCE_MARK ,
CYCLES_SINCE_MARK ,
NUMBER_OF_REPAIRS ,
PRODUCT_CODE ,
PRODUCT_TRANSACTION_ID ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15 ,
DFF_UPDATED_FLAG
--PARENT_LOT_NUMBER
)
select
l_serial_txn_id ,
sysdate ,
l_user_id ,
sysdate ,
l_user_id ,
l_login_id ,
l_req_id ,
l_prog_appl_id ,
l_prog_id ,
sysdate ,
--VENDOR_SERIAL_NUMBER ,
--VENDOR_LOT_NUMBER ,
MUT.SERIAL_NUMBER ,
MUT.SERIAL_NUMBER ,
--SERIAL_PREFIX ,
--ERROR_CODE ,
--GROUP_HEADER_ID ,
MSN.PARENT_SERIAL_NUMBER ,
--END_ITEM_UNIT_NUMBER ,
MUT.SERIAL_ATTRIBUTE_CATEGORY ,
MUT.ORIGINATION_DATE ,
MUT.C_ATTRIBUTE1 ,
MUT.C_ATTRIBUTE2 ,
MUT.C_ATTRIBUTE3 ,
MUT.C_ATTRIBUTE4 ,
MUT.C_ATTRIBUTE5 ,
MUT.C_ATTRIBUTE6 ,
MUT.C_ATTRIBUTE7 ,
MUT.C_ATTRIBUTE8 ,
MUT.C_ATTRIBUTE9 ,
MUT.C_ATTRIBUTE10 ,
MUT.C_ATTRIBUTE11 ,
MUT.C_ATTRIBUTE12 ,
MUT.C_ATTRIBUTE13 ,
MUT.C_ATTRIBUTE14 ,
MUT.C_ATTRIBUTE15 ,
MUT.C_ATTRIBUTE16 ,
MUT.C_ATTRIBUTE17 ,
MUT.C_ATTRIBUTE18 ,
MUT.C_ATTRIBUTE19 ,
MUT.C_ATTRIBUTE20 ,
MUT.D_ATTRIBUTE1 ,
MUT.D_ATTRIBUTE2 ,
MUT.D_ATTRIBUTE3 ,
MUT.D_ATTRIBUTE4 ,
MUT.D_ATTRIBUTE5 ,
MUT.D_ATTRIBUTE6 ,
MUT.D_ATTRIBUTE7 ,
MUT.D_ATTRIBUTE8 ,
MUT.D_ATTRIBUTE9 ,
MUT.D_ATTRIBUTE10 ,
MUT.N_ATTRIBUTE1 ,
MUT.N_ATTRIBUTE2 ,
MUT.N_ATTRIBUTE3 ,
MUT.N_ATTRIBUTE4 ,
MUT.N_ATTRIBUTE5 ,
MUT.N_ATTRIBUTE6 ,
MUT.N_ATTRIBUTE7 ,
MUT.N_ATTRIBUTE8 ,
MUT.N_ATTRIBUTE9 ,
MUT.N_ATTRIBUTE10 ,
MUT.STATUS_ID ,
MUT.TERRITORY_CODE ,
MUT.TIME_SINCE_NEW ,
MUT.CYCLES_SINCE_NEW ,
MUT.TIME_SINCE_OVERHAUL ,
MUT.CYCLES_SINCE_OVERHAUL ,
MUT.TIME_SINCE_REPAIR ,
MUT.CYCLES_SINCE_REPAIR ,
MUT.TIME_SINCE_VISIT ,
MUT.CYCLES_SINCE_VISIT ,
MUT.TIME_SINCE_MARK ,
MUT.CYCLES_SINCE_MARK ,
MUT.NUMBER_OF_REPAIRS ,
MUT.PRODUCT_CODE ,
MUT.PRODUCT_TRANSACTION_ID ,
MUT.ATTRIBUTE_CATEGORY ,
MUT.ATTRIBUTE1 ,
MUT.ATTRIBUTE2 ,
MUT.ATTRIBUTE3 ,
MUT.ATTRIBUTE4 ,
MUT.ATTRIBUTE5 ,
MUT.ATTRIBUTE6 ,
MUT.ATTRIBUTE7 ,
MUT.ATTRIBUTE8 ,
MUT.ATTRIBUTE9 ,
MUT.ATTRIBUTE10 ,
MUT.ATTRIBUTE11 ,
MUT.ATTRIBUTE12 ,
MUT.ATTRIBUTE13 ,
MUT.ATTRIBUTE14 ,
MUT.ATTRIBUTE15 ,
decode(nvl(MUT.ATTRIBUTE_CATEGORY,-1),-1,'N','Y')
from mtl_unit_transactions MUT,
mtl_serial_numbers MSN
where MUT.transaction_id = l_lot_txn_rec.serial_transaction_id
and MUT.serial_number = MSN.serial_number
and MSN.current_organization_id = MUT.ORGANIZATION_ID
and msn.last_transaction_id = l_mmt_rec.transaction_id; --l_lot_txn_rec.serial_transaction_id;
l_msg_tokens.delete;
p_msg_text => 'Inserted : ' || SQL%ROWCOUNT
|| ' rows into MSTT(Serial)',
p_stmt_num => l_stmt_num ,
p_msg_tokens => l_msg_tokens ,
p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
p_run_log_level => l_log_level
);
insert into mtl_serial_numbers_temp
(
TRANSACTION_TEMP_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
--VENDOR_SERIAL_NUMBER ,
--VENDOR_LOT_NUMBER ,
FM_SERIAL_NUMBER ,
TO_SERIAL_NUMBER ,
--SERIAL_PREFIX ,
--ERROR_CODE ,
--GROUP_HEADER_ID ,
PARENT_SERIAL_NUMBER ,
--END_ITEM_UNIT_NUMBER ,
SERIAL_ATTRIBUTE_CATEGORY ,
ORIGINATION_DATE ,
C_ATTRIBUTE1 ,
C_ATTRIBUTE2 ,
C_ATTRIBUTE3 ,
C_ATTRIBUTE4 ,
C_ATTRIBUTE5 ,
C_ATTRIBUTE6 ,
C_ATTRIBUTE7 ,
C_ATTRIBUTE8 ,
C_ATTRIBUTE9 ,
C_ATTRIBUTE10 ,
C_ATTRIBUTE11 ,
C_ATTRIBUTE12 ,
C_ATTRIBUTE13 ,
C_ATTRIBUTE14 ,
C_ATTRIBUTE15 ,
C_ATTRIBUTE16 ,
C_ATTRIBUTE17 ,
C_ATTRIBUTE18 ,
C_ATTRIBUTE19 ,
C_ATTRIBUTE20 ,
D_ATTRIBUTE1 ,
D_ATTRIBUTE2 ,
D_ATTRIBUTE3 ,
D_ATTRIBUTE4 ,
D_ATTRIBUTE5 ,
D_ATTRIBUTE6 ,
D_ATTRIBUTE7 ,
D_ATTRIBUTE8 ,
D_ATTRIBUTE9 ,
D_ATTRIBUTE10 ,
N_ATTRIBUTE1 ,
N_ATTRIBUTE2 ,
N_ATTRIBUTE3 ,
N_ATTRIBUTE4 ,
N_ATTRIBUTE5 ,
N_ATTRIBUTE6 ,
N_ATTRIBUTE7 ,
N_ATTRIBUTE8 ,
N_ATTRIBUTE9 ,
N_ATTRIBUTE10 ,
STATUS_ID ,
TERRITORY_CODE ,
TIME_SINCE_NEW ,
CYCLES_SINCE_NEW ,
TIME_SINCE_OVERHAUL ,
CYCLES_SINCE_OVERHAUL ,
TIME_SINCE_REPAIR ,
CYCLES_SINCE_REPAIR ,
TIME_SINCE_VISIT ,
CYCLES_SINCE_VISIT ,
TIME_SINCE_MARK ,
CYCLES_SINCE_MARK ,
NUMBER_OF_REPAIRS ,
PRODUCT_CODE ,
PRODUCT_TRANSACTION_ID ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15 ,
DFF_UPDATED_FLAG
--PARENT_LOT_NUMBER
)
select
l_temp_id ,
sysdate ,
l_user_id ,
sysdate ,
l_user_id ,
l_login_id ,
l_req_id ,
l_prog_appl_id ,
l_prog_id ,
sysdate ,
--VENDOR_SERIAL_NUMBER ,
--VENDOR_LOT_NUMBER ,
MUT.SERIAL_NUMBER ,
MUT.SERIAL_NUMBER ,
--SERIAL_PREFIX ,
--ERROR_CODE ,
--GROUP_HEADER_ID ,
MSN.PARENT_SERIAL_NUMBER ,
--END_ITEM_UNIT_NUMBER ,
MUT.SERIAL_ATTRIBUTE_CATEGORY ,
MUT.ORIGINATION_DATE ,
MUT.C_ATTRIBUTE1 ,
MUT.C_ATTRIBUTE2 ,
MUT.C_ATTRIBUTE3 ,
MUT.C_ATTRIBUTE4 ,
MUT.C_ATTRIBUTE5 ,
MUT.C_ATTRIBUTE6 ,
MUT.C_ATTRIBUTE7 ,
MUT.C_ATTRIBUTE8 ,
MUT.C_ATTRIBUTE9 ,
MUT.C_ATTRIBUTE10 ,
MUT.C_ATTRIBUTE11 ,
MUT.C_ATTRIBUTE12 ,
MUT.C_ATTRIBUTE13 ,
MUT.C_ATTRIBUTE14 ,
MUT.C_ATTRIBUTE15 ,
MUT.C_ATTRIBUTE16 ,
MUT.C_ATTRIBUTE17 ,
MUT.C_ATTRIBUTE18 ,
MUT.C_ATTRIBUTE19 ,
MUT.C_ATTRIBUTE20 ,
MUT.D_ATTRIBUTE1 ,
MUT.D_ATTRIBUTE2 ,
MUT.D_ATTRIBUTE3 ,
MUT.D_ATTRIBUTE4 ,
MUT.D_ATTRIBUTE5 ,
MUT.D_ATTRIBUTE6 ,
MUT.D_ATTRIBUTE7 ,
MUT.D_ATTRIBUTE8 ,
MUT.D_ATTRIBUTE9 ,
MUT.D_ATTRIBUTE10 ,
MUT.N_ATTRIBUTE1 ,
MUT.N_ATTRIBUTE2 ,
MUT.N_ATTRIBUTE3 ,
MUT.N_ATTRIBUTE4 ,
MUT.N_ATTRIBUTE5 ,
MUT.N_ATTRIBUTE6 ,
MUT.N_ATTRIBUTE7 ,
MUT.N_ATTRIBUTE8 ,
MUT.N_ATTRIBUTE9 ,
MUT.N_ATTRIBUTE10 ,
MUT.STATUS_ID ,
MUT.TERRITORY_CODE ,
MUT.TIME_SINCE_NEW ,
MUT.CYCLES_SINCE_NEW ,
MUT.TIME_SINCE_OVERHAUL ,
MUT.CYCLES_SINCE_OVERHAUL ,
MUT.TIME_SINCE_REPAIR ,
MUT.CYCLES_SINCE_REPAIR ,
MUT.TIME_SINCE_VISIT ,
MUT.CYCLES_SINCE_VISIT ,
MUT.TIME_SINCE_MARK ,
MUT.CYCLES_SINCE_MARK ,
MUT.NUMBER_OF_REPAIRS ,
MUT.PRODUCT_CODE ,
MUT.PRODUCT_TRANSACTION_ID ,
MUT.ATTRIBUTE_CATEGORY ,
MUT.ATTRIBUTE1 ,
MUT.ATTRIBUTE2 ,
MUT.ATTRIBUTE3 ,
MUT.ATTRIBUTE4 ,
MUT.ATTRIBUTE5 ,
MUT.ATTRIBUTE6 ,
MUT.ATTRIBUTE7 ,
MUT.ATTRIBUTE8 ,
MUT.ATTRIBUTE9 ,
MUT.ATTRIBUTE10 ,
MUT.ATTRIBUTE11 ,
MUT.ATTRIBUTE12 ,
MUT.ATTRIBUTE13 ,
MUT.ATTRIBUTE14 ,
MUT.ATTRIBUTE15 ,
decode(nvl(MUT.ATTRIBUTE_CATEGORY,-1),-1,'N','Y')
-- PARENT_LOT_NUMBER
from mtl_unit_transactions MUT,
mtl_serial_numbers MSN
where MUT.transaction_id = l_mmt_rec.transaction_id
and MUT.serial_number = MSN.serial_number
and MSN.current_organization_id = MUT.ORGANIZATION_ID
and msn.last_transaction_id = l_mmt_rec.transaction_id;
l_msg_tokens.delete;
p_msg_text => 'Inserted : ' || SQL%ROWCOUNT
|| ' rows into MSTT(Serial)',
p_stmt_num => l_stmt_num ,
p_msg_tokens => l_msg_tokens ,
p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
p_run_log_level => l_log_level
);