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 439: FROM mtl_serial_numbers_temp

435: , TO_CHAR(n_attribute9)
436: , TO_CHAR(n_attribute10)
437: , status_id
438: , territory_code
439: FROM mtl_serial_numbers_temp
440: WHERE transaction_temp_id = p_transaction_temp_id
441: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
442:
443: l_input_idx BINARY_INTEGER;

Line 1676: FROM mtl_serial_numbers_temp

1672: , n_attribute8
1673: , n_attribute9
1674: , n_attribute10
1675: , territory_code
1676: FROM mtl_serial_numbers_temp
1677: WHERE transaction_temp_id = p_serial_temp_id
1678: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
1679:
1680: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 2165: FROM mtl_serial_numbers_temp

2161: , TO_CHAR(n_attribute9)
2162: , TO_CHAR(n_attribute10)
2163: , status_id
2164: , territory_code
2165: FROM mtl_serial_numbers_temp
2166: WHERE transaction_temp_id = p_transaction_temp_id
2167: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
2168: /* Bug 3622025 -- Added the LPAD function in the above where clause */
2169:

Line 2706: FROM mtl_serial_numbers_temp

2702: , attribute12
2703: , attribute13
2704: , attribute14
2705: , attribute15
2706: FROM mtl_serial_numbers_temp
2707: WHERE transaction_temp_id = p_transaction_temp_id
2708: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
2709: /* Bug 3622025 -- Added the LPAD function in the above where clause */
2710: ELSE

Line 4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;

4797: l_return_status VARCHAR2(1);
4798: l_msg_data VARCHAR2(2000);
4799: l_msg_count NUMBER;
4800: l_upd_count NUMBER;
4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;

Line 4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;

4798: l_msg_data VARCHAR2(2000);
4799: l_msg_count NUMBER;
4800: l_upd_count NUMBER;
4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;

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

4799: l_msg_count NUMBER;
4800: l_upd_count NUMBER;
4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;

Line 4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;

4800: l_upd_count NUMBER;
4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;

Line 4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;

4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;

Line 4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;

4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;

Line 4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;

4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;

Line 4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;

4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
4812:

Line 4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;

4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
4812:
4813:

Line 4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;

4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
4812:
4813:
4814: l_sys_date date := NULL;

Line 4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;

4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
4812:
4813:
4814: l_sys_date date := NULL;
4815: l_date2 date := NULL;

Line 4894: from mtl_serial_numbers_temp

4890: , CYCLES_SINCE_VISIT
4891: , TIME_SINCE_MARK
4892: , CYCLES_SINCE_MARK
4893: , NUMBER_OF_REPAIRS
4894: from mtl_serial_numbers_temp
4895: where transaction_temp_id = p_transaction_temp_id
4896: and fm_serial_number = p_fm_serial_number and to_serial_number = p_to_serial_number;
4897: l_input_idx BINARY_INTEGER;
4898:

Line 5303: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

5299: -- anywhere. for performance reason.
5300: /*****
5301: SELECT count(*)
5302: into l_upd_count
5303: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
5304: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5305: 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)
5306: AND Lpad(msnt.fm_serial_number,30) = l_fm_serial_number
5307: AND Lpad(msnt.to_serial_number,30) = l_to_serial_number;

Line 5511: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

5507: , msnt.attribute12
5508: , msnt.attribute13
5509: , msnt.attribute14
5510: , msnt.attribute15
5511: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
5512: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5513: AND msn.current_organization_id = p_organization_id
5514: AND msn.inventory_item_id = p_inventory_item_id
5515: AND lpad(msn.serial_number,30) between lpad(msnt.fm_serial_number,30) AND lpad(msnt.to_serial_number,30)

Line 5717: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

5713: , msnt.attribute12
5714: , msnt.attribute13
5715: , msnt.attribute14
5716: , msnt.attribute15
5717: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
5718: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5719: AND msn.current_organization_id = p_organization_id
5720: AND msn.inventory_item_id = p_inventory_item_id
5721: AND lpad(msn.serial_number,30) = lpad(msnt.fm_serial_number,30)