eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_DIAGNOSTICS_TEMP

Line 4050: l_object_name := l_schema_name||'.csi_diagnostics_temp';

4046: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4047: RAISE fnd_api.g_exc_error;
4048: END IF;
4049:
4050: l_object_name := l_schema_name||'.csi_diagnostics_temp';
4051:
4052: -- cleans up the temporary process table
4053: truncate_table(l_object_name);
4054:

Line 4332: FROM csi_diagnostics_temp

4328: END IF;
4329:
4330: BEGIN
4331: SELECT 'Y' INTO l_already_inserted
4332: FROM csi_diagnostics_temp
4333: WHERE serial_number = srl_rec.serial_number
4334: AND inventory_item_id = srl_rec.item_id
4335: AND mtl_txn_id = txn_rec.mtl_txn_id;
4336: EXCEPTION

Line 4362: INSERT INTO csi_diagnostics_temp(

4358: x_csi_txn_type_id => l_csi_txn_type_id);
4359:
4360: l_diag_seq_id := l_diag_seq_id + 1;
4361:
4362: INSERT INTO csi_diagnostics_temp(
4363: diag_seq_id,
4364: serial_number,
4365: lot_number,
4366: serial_control_code,

Line 4518: DELETE FROM csi_diagnostics_temp

4514: last_updated_by = fnd_global.user_id
4515: WHERE inv_material_transaction_id = l_mtl_txn_id_tab(ind)
4516: AND processed_flag in ('E', 'R');
4517:
4518: DELETE FROM csi_diagnostics_temp
4519: WHERE mtl_txn_id = l_mtl_txn_id_tab(ind)
4520: AND error_flag = 'E';
4521:
4522: -- for wip errors that are knocked we write a csi transaction '

Line 4605: UPDATE csi_diagnostics_temp

4601: ELSE
4602: l_expire_flag := 'N';
4603: END IF;
4604:
4605: UPDATE csi_diagnostics_temp
4606: SET process_flag = 'M',
4607: process_code = 'SOISHIP',
4608: expire_flag = l_expire_flag,
4609: temporary_message = 'Updating the srlsoi instance with returned RMA info.'

Line 4614: UPDATE csi_diagnostics_temp

4610: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;
4611:
4612: ELSE
4613:
4614: UPDATE csi_diagnostics_temp
4615: SET process_flag = 'M',
4616: process_code = 'SOISHIP',
4617: temporary_message = 'Creating/Updating a non serial instance with staging info'
4618: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4624: UPDATE csi_diagnostics_temp

4620: END IF;
4621:
4622: ELSE
4623:
4624: UPDATE csi_diagnostics_temp
4625: SET process_flag = 'M',
4626: process_code = 'SHIP',
4627: temporary_message = 'Creating/Updating the instance with staging info'
4628: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4639: UPDATE csi_diagnostics_temp

4635: p_diag_txn_rec IN diag_txn_rec)
4636: IS
4637: BEGIN
4638:
4639: UPDATE csi_diagnostics_temp
4640: SET process_flag = 'M',
4641: process_code = 'RMA',
4642: temporary_message = 'Just mark error transaction to be re-processed'
4643: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4651: UPDATE csi_diagnostics_temp

4647: PROCEDURE preprocess_wipissue(
4648: p_diag_txn_rec IN diag_txn_rec)
4649: IS
4650: BEGIN
4651: UPDATE csi_diagnostics_temp
4652: SET process_flag = 'M',
4653: process_code = 'WIPISSUE',
4654: temporary_message = 'Stamp the inv location from serial and mark it FOR processing'
4655: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4663: UPDATE csi_diagnostics_temp

4659: p_diag_txn_rec IN diag_txn_rec)
4660: IS
4661: BEGIN
4662:
4663: UPDATE csi_diagnostics_temp
4664: SET process_flag = 'M',
4665: process_code = 'WIPRETURN',
4666: temporary_message = 'Make it a WIP instance and allow re-processing'
4667: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4676: UPDATE csi_diagnostics_temp

4672: p_diag_txn_rec IN diag_txn_rec)
4673: IS
4674: BEGIN
4675:
4676: UPDATE csi_diagnostics_temp
4677: SET process_flag = 'M',
4678: process_code = 'WIPCOMPL',
4679: temporary_message = 'Mark the error FOR re-processing.'
4680: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4689: UPDATE csi_diagnostics_temp

4685: p_diag_txn_rec IN diag_txn_rec)
4686: IS
4687: BEGIN
4688:
4689: UPDATE csi_diagnostics_temp
4690: SET process_flag = 'M',
4691: process_code = 'MISCRCPT',
4692: temporary_message = 'Stamp the INV location from serial'
4693: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4702: UPDATE csi_diagnostics_temp

4698: p_diag_txn_rec IN diag_txn_rec)
4699: IS
4700: BEGIN
4701:
4702: UPDATE csi_diagnostics_temp
4703: SET process_flag = 'M',
4704: process_code = 'MISCISSUE',
4705: temporary_message = 'Stamp the INV location from serial'
4706: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4715: UPDATE csi_diagnostics_temp

4711: p_diag_txn_rec IN diag_txn_rec)
4712: IS
4713: BEGIN
4714:
4715: UPDATE csi_diagnostics_temp
4716: SET process_flag = 'M',
4717: process_code = 'SIXFER',
4718: temporary_message = 'Stamp the inv location from serial and mark it FOR processing'
4719: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4728: UPDATE csi_diagnostics_temp

4724: PROCEDURE preprocess_projreceipt(
4725: p_diag_txn_rec IN diag_txn_rec)
4726: IS
4727: BEGIN
4728: UPDATE csi_diagnostics_temp
4729: SET process_flag = 'M',
4730: process_code = 'PROJRCPT',
4731: temporary_message = 'Stamp the project location from serial and mark it for processing'
4732: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4739: UPDATE csi_diagnostics_temp

4735: PROCEDURE preprocess_interorgreceipt(
4736: p_diag_txn_rec IN diag_txn_rec)
4737: IS
4738: BEGIN
4739: UPDATE csi_diagnostics_temp
4740: SET process_flag = 'M',
4741: process_code = 'IORGRCPT',
4742: temporary_message = 'Stamp the intransit location from serial and mark it for processing'
4743: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4750: UPDATE csi_diagnostics_temp

4746: PROCEDURE preprocess_isoreceipt(
4747: p_diag_txn_rec IN diag_txn_rec)
4748: IS
4749: BEGIN
4750: UPDATE csi_diagnostics_temp
4751: SET process_flag = 'M',
4752: process_code = 'ISORCPT',
4753: temporary_message = 'Stamp the intransit location from serial and mark it for processing'
4754: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4761: UPDATE csi_diagnostics_temp

4757: PROCEDURE preprocess_intransitship(
4758: p_diag_txn_rec IN diag_txn_rec)
4759: IS
4760: BEGIN
4761: UPDATE csi_diagnostics_temp
4762: SET process_flag = 'M',
4763: process_code = 'INTRSHIP',
4764: temporary_message = 'Stamp the inv location from serial and mark it for processing'
4765: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;

Line 4772: UPDATE csi_diagnostics_temp

4768: PROCEDURE preprocess_unidentified(
4769: p_diag_txn_rec IN diag_txn_rec)
4770: IS
4771: BEGIN
4772: UPDATE csi_diagnostics_temp
4773: SET process_flag = 'R',
4774: temporary_message = 'Marking this for re-process.'
4775: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;
4776: END preprocess_unidentified;

Line 4931: UPDATE csi_diagnostics_temp

4927: IF l_preprocessed THEN
4928: FOR l_ind IN 1 .. l_error_ind-1
4929: LOOP
4930: IF nvl(p_diag_txn_tbl(l_ind).error_flag,'P') = 'E' THEN
4931: UPDATE csi_diagnostics_temp
4932: SET process_flag = 'R',
4933: temporary_message = 'Marking it for re-process'
4934: WHERE diag_seq_id = p_diag_txn_tbl(l_ind).diag_seq_id;
4935: END IF;

Line 4954: UPDATE csi_diagnostics_temp

4950: LOOP
4951:
4952: IF nvl(p_diag_txn_tbl(l_ind).error_flag,'P') = 'E' THEN
4953:
4954: UPDATE csi_diagnostics_temp
4955: SET process_flag = 'X',
4956: temporary_message = 'Succeeding txn processed in IB for this serial'
4957: WHERE diag_seq_id = p_diag_txn_tbl(l_ind).diag_seq_id;
4958:

Line 4969: FROM csi_diagnostics_temp;

4965: PROCEDURE init_diag_temp
4966: IS
4967: CURSOR diag_cur IS
4968: SELECT rowid row_id
4969: FROM csi_diagnostics_temp;
4970:
4971: BEGIN
4972:
4973: FOR diag_rec IN diag_cur

Line 4976: UPDATE csi_diagnostics_temp

4972:
4973: FOR diag_rec IN diag_cur
4974: LOOP
4975:
4976: UPDATE csi_diagnostics_temp
4977: SET process_flag = 'N',
4978: process_code = null,
4979: entangled_flag = null,
4980: expire_flag = null,

Line 5043: FROM csi_diagnostics_temp

5039: l_current_date date;
5040:
5041: CURSOR m_cur IS
5042: SELECT distinct mtl_creation_date, mtl_txn_id
5043: FROM csi_diagnostics_temp
5044: WHERE nvl(process_flag, 'N') = 'M'
5045: ORDER BY mtl_creation_date asc, mtl_txn_id asc;
5046:
5047: CURSOR m_srl_cur(p_mtl_txn_id IN number) IS

Line 5054: FROM csi_diagnostics_temp

5050: inventory_item_id,
5051: instance_id,
5052: lot_control_code,
5053: process_flag
5054: FROM csi_diagnostics_temp
5055: WHERE mtl_txn_id = p_mtl_txn_id
5056: AND nvl(process_flag, 'N') <> 'M';
5057:
5058: -- already marked earlier transactions

Line 5065: FROM csi_diagnostics_temp

5061: p_item_id IN number,
5062: p_mtl_creation_date IN date)
5063: IS
5064: SELECT diag_seq_id
5065: FROM csi_diagnostics_temp
5066: WHERE serial_number = p_serial_number
5067: AND inventory_item_id = p_item_id
5068: AND mtl_creation_date < p_mtl_creation_date
5069: AND nvl(process_flag,'N') = 'M';

Line 5078: FROM csi_diagnostics_temp

5074: p_item_id IN number,
5075: p_mtl_creation_date IN date)
5076: IS
5077: SELECT diag_seq_id
5078: FROM csi_diagnostics_temp
5079: WHERE serial_number = p_serial_number
5080: AND inventory_item_id = p_item_id
5081: AND mtl_creation_date > p_mtl_creation_date
5082: AND nvl(process_flag,'N') = 'M'

Line 5094: FROM csi_diagnostics_temp

5090: SELECT diag_seq_id,
5091: mtl_txn_id,
5092: csi_txn_id,
5093: mtl_txn_date
5094: FROM csi_diagnostics_temp
5095: WHERE serial_number = p_serial_number
5096: AND inventory_item_id = p_item_id
5097: AND mtl_creation_date < p_mtl_creation_date
5098: ORDER BY mtl_creation_date desc, mtl_txn_id desc;

Line 5117: FROM csi_diagnostics_temp

5113: -- check if this txn is still there to be processed in the loop
5114: BEGIN
5115: SELECT process_code
5116: INTO l_process_code
5117: FROM csi_diagnostics_temp
5118: WHERE mtl_txn_id = m_rec.mtl_txn_id
5119: AND nvl(process_flag,'N') = 'M' -- marked for update
5120: AND rownum = 1;
5121: EXCEPTION

Line 5148: UPDATE csi_diagnostics_temp

5144: --skip it for marking this batch
5145: FOR m_srl_rec IN m_srl_cur(m_rec.mtl_txn_id)
5146: LOOP
5147: IF nvl(m_srl_rec.process_flag, 'N') = 'X' THEN
5148: UPDATE csi_diagnostics_temp
5149: SET process_flag = 'N',
5150: temporary_message = 'updating for entanglement processing'
5151: WHERE diag_seq_id = m_srl_rec.diag_seq_id;
5152: END IF;

Line 5162: UPDATE csi_diagnostics_temp

5158: -- the same way as the current serial
5159: FOR m_srl_rec IN m_srl_cur(m_rec.mtl_txn_id)
5160: LOOP
5161:
5162: UPDATE csi_diagnostics_temp
5163: SET process_code = l_process_code,
5164: process_flag = 'M',
5165: temporary_message = 'updating for entanglement processing'
5166: WHERE diag_seq_id = m_srl_rec.diag_seq_id;

Line 5176: FROM csi_diagnostics_temp

5172:
5173: -- get the max processed material transaction id
5174: SELECT nvl(min(diag_seq_id), -999999)
5175: INTO l_p_diag_seq_id
5176: FROM csi_diagnostics_temp
5177: WHERE serial_number = m_srl_rec.serial_number
5178: AND inventory_item_id = m_srl_rec.inventory_item_id
5179: AND mtl_creation_date > m_rec.mtl_creation_date
5180: AND csi_txn_id is not null;

Line 5188: FROM csi_diagnostics_temp

5184: SELECT mtl_txn_id,
5185: mtl_creation_date
5186: INTO l_p_mtl_txn_id,
5187: l_p_mtl_creation_date
5188: FROM csi_diagnostics_temp
5189: WHERE diag_seq_id = l_p_diag_seq_id;
5190:
5191: IF check_contracts(m_srl_rec.instance_id) THEN
5192: l_contracts_flag := 'Y';

Line 5199: FROM csi_diagnostics_temp

5195: END IF;
5196:
5197: SELECT csi_txn_id
5198: INTO l_p_csi_txn_id
5199: FROM csi_diagnostics_temp
5200: WHERE serial_number = m_srl_rec.serial_number
5201: AND inventory_item_id = m_srl_rec.inventory_item_id
5202: AND mtl_txn_id = l_p_mtl_txn_id;
5203:

Line 5269: UPDATE csi_diagnostics_temp

5265: p_item_id => m_srl_rec.inventory_item_id,
5266: p_mtl_creation_date => m_rec.mtl_creation_date)
5267: LOOP
5268:
5269: UPDATE csi_diagnostics_temp
5270: SET process_flag = 'R',
5271: temporary_message = 'unmarking the serial to be processed after entanglement.'
5272: WHERE diag_seq_id = p_lt_rec.diag_seq_id;
5273:

Line 5313: UPDATE csi_diagnostics_temp

5309: x_return_status => l_return_status,
5310: x_msg_count => l_msg_count,
5311: x_msg_data => l_msg_data );
5312:
5313: UPDATE csi_diagnostics_temp
5314: SET csi_txn_id = l_txn_rec.transaction_id,
5315: error_flag = 'P'
5316: WHERE diag_seq_id = missing_csi_rec.diag_seq_id;
5317:

Line 5346: FROM csi_diagnostics_temp

5342:
5343: CURSOR diag_srl_cur IS
5344: SELECT serial_number,
5345: inventory_item_id
5346: FROM csi_diagnostics_temp
5347: GROUP BY serial_number, inventory_item_id;
5348:
5349: CURSOR diag_txn_cur(p_serial_number IN varchar2, p_item_id IN number) IS
5350: SELECT diag_seq_id,

Line 5366: FROM csi_diagnostics_temp

5362: create_flag,
5363: source_type,
5364: error_flag ,
5365: mtl_item_revision
5366: FROM csi_diagnostics_temp
5367: WHERE serial_number = p_serial_number
5368: AND inventory_item_id = p_item_id
5369: ORDER by mtl_creation_date desc, mtl_txn_id desc;
5370:

Line 5573: p_rec in csi_diagnostics_temp%rowtype,

5569:
5570: END report_header;
5571:
5572: PROCEDURE report_body(
5573: p_rec in csi_diagnostics_temp%rowtype,
5574: px_serial_number in out nocopy varchar2,
5575: px_item_id in out nocopy number)
5576: is
5577: l_mtl_txn_date date;

Line 5634: FROM csi_diagnostics_temp

5630: PROCEDURE spool_srldata(p_mode in varchar2 default 'ALL' ) is
5631:
5632: CURSOR dump_all_cur is
5633: SELECT *
5634: FROM csi_diagnostics_temp
5635: ORDER BY serial_number, inventory_item_id, mtl_creation_date desc, mtl_txn_id desc;
5636:
5637: CURSOR dump_fixable_cur is
5638: SELECT * FROM csi_diagnostics_temp A

Line 5638: SELECT * FROM csi_diagnostics_temp A

5634: FROM csi_diagnostics_temp
5635: ORDER BY serial_number, inventory_item_id, mtl_creation_date desc, mtl_txn_id desc;
5636:
5637: CURSOR dump_fixable_cur is
5638: SELECT * FROM csi_diagnostics_temp A
5639: WHERE exists (
5640: SELECT 'X' FROM csi_diagnostics_temp B
5641: WHERE B.serial_number = A.serial_number
5642: AND B.inventory_item_id = A.inventory_item_id

Line 5640: SELECT 'X' FROM csi_diagnostics_temp B

5636:
5637: CURSOR dump_fixable_cur is
5638: SELECT * FROM csi_diagnostics_temp A
5639: WHERE exists (
5640: SELECT 'X' FROM csi_diagnostics_temp B
5641: WHERE B.serial_number = A.serial_number
5642: AND B.inventory_item_id = A.inventory_item_id
5643: AND B.process_flag in ('M', 'X', 'R'))
5644: ORDER BY A.serial_number, a.inventory_item_id, a.mtl_creation_date desc, a.mtl_txn_id desc;

Line 5647: SELECT * FROM csi_diagnostics_temp A

5643: AND B.process_flag in ('M', 'X', 'R'))
5644: ORDER BY A.serial_number, a.inventory_item_id, a.mtl_creation_date desc, a.mtl_txn_id desc;
5645:
5646: CURSOR dump_nonfixable_cur is
5647: SELECT * FROM csi_diagnostics_temp A
5648: WHERE not exists (
5649: SELECT 'X' FROM csi_diagnostics_temp B
5650: WHERE B.serial_number = A.serial_number
5651: AND B.inventory_item_id = A.inventory_item_id

Line 5649: SELECT 'X' FROM csi_diagnostics_temp B

5645:
5646: CURSOR dump_nonfixable_cur is
5647: SELECT * FROM csi_diagnostics_temp A
5648: WHERE not exists (
5649: SELECT 'X' FROM csi_diagnostics_temp B
5650: WHERE B.serial_number = A.serial_number
5651: AND B.inventory_item_id = A.inventory_item_id
5652: AND B.process_flag in ('M', 'X', 'R'))
5653: ORDER BY A.serial_number, a.inventory_item_id, a.mtl_creation_date desc, a.mtl_txn_id desc;

Line 5656: SELECT * FROM csi_diagnostics_temp A

5652: AND B.process_flag in ('M', 'X', 'R'))
5653: ORDER BY A.serial_number, a.inventory_item_id, a.mtl_creation_date desc, a.mtl_txn_id desc;
5654:
5655: CURSOR dump_errors_cur is
5656: SELECT * FROM csi_diagnostics_temp A
5657: WHERE exists (
5658: SELECT 'X' FROM csi_diagnostics_temp B
5659: WHERE B.serial_number = A.serial_number
5660: AND B.inventory_item_id = A.inventory_item_id

Line 5658: SELECT 'X' FROM csi_diagnostics_temp B

5654:
5655: CURSOR dump_errors_cur is
5656: SELECT * FROM csi_diagnostics_temp A
5657: WHERE exists (
5658: SELECT 'X' FROM csi_diagnostics_temp B
5659: WHERE B.serial_number = A.serial_number
5660: AND B.inventory_item_id = A.inventory_item_id
5661: AND B.process_flag = 'E')
5662: ORDER BY A.serial_number, a.inventory_item_id, a.mtl_creation_date desc, a.mtl_txn_id desc;

Line 6010: FROM csi_diagnostics_temp

6006: CURSOR knock_cur is
6007: SELECT mtl_txn_id,
6008: mtl_src_type_id,
6009: mtl_txn_date
6010: FROM csi_diagnostics_temp
6011: WHERE process_flag = 'X';
6012:
6013: l_txn_rec csi_datastructures_pub.transaction_rec;
6014: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6446: FROM csi_diagnostics_temp

6442: CURSOR txn_cur is
6443: SELECT distinct mtl_txn_id ,
6444: inventory_item_id,
6445: organization_id
6446: FROM csi_diagnostics_temp
6447: WHERE process_flag = 'M'
6448: AND process_code = 'SOISHIP';
6449:
6450: CURSOR returned_serial_cur(p_mtl_txn_id IN number) is

Line 6466: FROM csi_diagnostics_temp cdt

6462: nvl(cdt.create_flag, 'Y') create_flag,
6463: nvl(cdt.expire_flag, 'N') expire_flag,
6464: cdt.serial_control_code,
6465: cdt.lot_control_code
6466: FROM csi_diagnostics_temp cdt
6467: WHERE cdt.mtl_txn_id = p_mtl_txn_id
6468: AND cdt.process_flag = 'M'
6469: AND nvl(cdt.create_flag, 'Y') = 'N'; -- marked FOR processing
6470:

Line 6590: UPDATE csi_diagnostics_temp

6586:
6587: l_serials_fixed := FALSE;
6588: rollback to soiship_srl_upd;
6589:
6590: UPDATE csi_diagnostics_temp
6591: SET process_flag = 'E',
6592: temporary_message = l_error_message
6593: WHERE diag_seq_id = returned_serial_rec.diag_seq_id;
6594:

Line 6742: UPDATE csi_diagnostics_temp

6738: END IF;
6739:
6740: END IF;
6741:
6742: UPDATE csi_diagnostics_temp
6743: SET process_flag = 'P',
6744: temporary_message = 'Sales order issue instance staged.'
6745: WHERE mtl_txn_id = txn_rec.mtl_txn_id;
6746:

Line 6759: UPDATE csi_diagnostics_temp

6755: EXCEPTION
6756: WHEN fnd_api.g_exc_error THEN
6757: rollback to stage_soiship_instances;
6758: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
6759: UPDATE csi_diagnostics_temp
6760: SET process_flag = 'E',
6761: temporary_message = l_error_message
6762: WHERE mtl_txn_id = txn_rec.mtl_txn_id;
6763: END;

Line 6882: FROM csi_diagnostics_temp

6878: SELECT mtl_txn_id,
6879: mtl_action_id,
6880: mtl_src_type_id,
6881: mtl_type_id
6882: FROM csi_diagnostics_temp
6883: WHERE inventory_item_id = p_item_id
6884: AND serial_number = p_serial_number
6885: AND diag_seq_id > p_diag_seq_id
6886: ORDER by diag_seq_id asc;

Line 8599: UPDATE csi_diagnostics_temp

8595: x_error_message => l_error_message);
8596: END IF;
8597:
8598: IF l_return_status = fnd_api.g_ret_sts_success THEN
8599: UPDATE csi_diagnostics_temp
8600: SET process_flag = 'P'
8601: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;
8602:
8603: UPDATE csi_txn_errors

Line 8611: UPDATE csi_diagnostics_temp

8607: last_updated_by = fnd_global.user_id
8608: WHERE inv_material_transaction_id = p_diag_txn_rec.mtl_txn_id
8609: AND processed_flag = 'E';
8610: ELSE
8611: UPDATE csi_diagnostics_temp
8612: SET process_flag = 'E',
8613: temporary_message = l_error_message
8614: WHERE diag_seq_id = p_diag_txn_rec.diag_seq_id;
8615: END IF;

Line 8638: FROM csi_diagnostics_temp cdt

8634: cdt.serial_control_code,
8635: cdt.lot_control_code,
8636: cdt.source_type,
8637: cdt.internal_party_id
8638: FROM csi_diagnostics_temp cdt
8639: WHERE nvl(cdt.process_flag ,'N') = 'M'; -- marked FOR processing
8640:
8641: CURSOR reprocess_cur IS
8642: SELECT distinct mtl_txn_id

Line 8643: FROM csi_diagnostics_temp

8639: WHERE nvl(cdt.process_flag ,'N') = 'M'; -- marked FOR processing
8640:
8641: CURSOR reprocess_cur IS
8642: SELECT distinct mtl_txn_id
8643: FROM csi_diagnostics_temp
8644: WHERE process_flag = 'R';
8645:
8646: l_diag_txn_rec diag_txn_rec;
8647:

Line 16288: FROM csi_diagnostics_temp cdt,

16284: SELECT cdt.mtl_txn_name,
16285: cdt.mtl_txn_id,
16286: cdt.mtl_txn_date,
16287: cte.error_text
16288: FROM csi_diagnostics_temp cdt,
16289: csi_txn_errors cte
16290: WHERE cdt.inventory_item_id = p_item_id
16291: AND cdt.serial_number = p_serial_number
16292: AND cte.inv_material_transaction_id = cdt.mtl_txn_id