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.INV_SERIAL_NUMBER_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 472: FROM mtl_serial_numbers_temp

468: , TO_CHAR(n_attribute9)
469: , TO_CHAR(n_attribute10)
470: , status_id
471: , territory_code
472: FROM mtl_serial_numbers_temp
473: WHERE transaction_temp_id = p_transaction_temp_id
474: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
475:
476: l_input_idx BINARY_INTEGER;

Line 2007: FROM mtl_serial_numbers_temp

2003: , n_attribute8
2004: , n_attribute9
2005: , n_attribute10
2006: , territory_code
2007: FROM mtl_serial_numbers_temp
2008: WHERE transaction_temp_id = p_serial_temp_id
2009: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
2010:
2011: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 2496: FROM mtl_serial_numbers_temp

2492: , TO_CHAR(n_attribute9)
2493: , TO_CHAR(n_attribute10)
2494: , status_id
2495: , territory_code
2496: FROM mtl_serial_numbers_temp
2497: WHERE transaction_temp_id = p_transaction_temp_id
2498: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
2499: /* Bug 3622025 -- Added the LPAD function in the above where clause */
2500:

Line 3037: FROM mtl_serial_numbers_temp

3033: , attribute12
3034: , attribute13
3035: , attribute14
3036: , attribute15
3037: FROM mtl_serial_numbers_temp
3038: WHERE transaction_temp_id = p_transaction_temp_id
3039: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
3040: /* Bug 3622025 -- Added the LPAD function in the above where clause */
3041: ELSE

Line 5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;

5184: l_return_status VARCHAR2(1);
5185: l_msg_data VARCHAR2(2000);
5186: l_msg_count NUMBER;
5187: l_upd_count NUMBER;
5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;

Line 5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;

5185: l_msg_data VARCHAR2(2000);
5186: l_msg_count NUMBER;
5187: l_upd_count NUMBER;
5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;

Line 5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;

5186: l_msg_count NUMBER;
5187: l_upd_count NUMBER;
5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;

Line 5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;

5187: l_upd_count NUMBER;
5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;

Line 5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;

5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;

Line 5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;

5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;

Line 5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;

5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;

Line 5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;

5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
5199:

Line 5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;

5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
5199:
5200:

Line 5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;

5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
5199:
5200:
5201: l_sys_date date := NULL;

Line 5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;

5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
5199:
5200:
5201: l_sys_date date := NULL;
5202: l_date2 date := NULL;

Line 5281: from mtl_serial_numbers_temp

5277: , CYCLES_SINCE_VISIT
5278: , TIME_SINCE_MARK
5279: , CYCLES_SINCE_MARK
5280: , NUMBER_OF_REPAIRS
5281: from mtl_serial_numbers_temp
5282: where transaction_temp_id = p_transaction_temp_id
5283: and fm_serial_number = p_fm_serial_number and to_serial_number = p_to_serial_number;
5284: l_input_idx BINARY_INTEGER;
5285:

Line 5690: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

5686: -- anywhere. for performance reason.
5687: /*****
5688: SELECT count(*)
5689: into l_upd_count
5690: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
5691: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5692: AND lpad(msn.serial_number, 30) between lpad(msnt.fm_serial_number,30) AND LPAD(NVL(msnt.to_serial_number, msnt.fm_serial_number),30)
5693: AND Lpad(msnt.fm_serial_number,30) = l_fm_serial_number
5694: AND Lpad(msnt.to_serial_number,30) = l_to_serial_number;

Line 5898: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

5894: , msnt.attribute12
5895: , msnt.attribute13
5896: , msnt.attribute14
5897: , msnt.attribute15
5898: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
5899: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5900: AND msn.current_organization_id = p_organization_id
5901: AND msn.inventory_item_id = p_inventory_item_id
5902: AND lpad(msn.serial_number,30) between lpad(msnt.fm_serial_number,30) AND lpad(msnt.to_serial_number,30)

Line 6104: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

6100: , msnt.attribute12
6101: , msnt.attribute13
6102: , msnt.attribute14
6103: , msnt.attribute15
6104: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
6105: WHERE msnt.transaction_temp_id = p_transaction_temp_id
6106: AND msn.current_organization_id = p_organization_id
6107: AND msn.inventory_item_id = p_inventory_item_id
6108: AND lpad(msn.serial_number,30) = lpad(msnt.fm_serial_number,30)