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_TXN_VALIDATIONS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 1927: from mtl_serial_numbers_temp msnt,

1923:
1924: begin
1925: select 1
1926: into l_cnt
1927: from mtl_serial_numbers_temp msnt,
1928: mtl_transaction_lots_temp mtlt,
1929: mtl_material_transactions_temp mmtt
1930: where mmtt.organization_id = p_org_id
1931: and mmtt.inventory_item_id = l_inventory_item_id

Line 1985: from mtl_serial_numbers_temp msnt,

1981: BEGIN
1982:
1983: select 1
1984: into l_cnt
1985: from mtl_serial_numbers_temp msnt,
1986: mtl_transaction_lots_temp mtlt,
1987: mtl_material_transactions_temp mmtt
1988: where mmtt.organization_id = p_org_id
1989: and mmtt.inventory_item_id = p_item_id

Line 3322: from mtl_serial_numbers_temp

3318: if p_lot is null then
3319: begin
3320: select 1
3321: into l_serial_exist
3322: from mtl_serial_numbers_temp
3323: where transaction_temp_id = l_transaction_temp_id
3324: and p_serial between fm_serial_number and nvl(to_serial_number, fm_serial_number);
3325: exception
3326: when others then

Line 3334: mtl_serial_numbers_temp msnt

3330: begin
3331: select 1
3332: into l_serial_exist
3333: from mtl_transaction_lots_temp mtlt,
3334: mtl_serial_numbers_temp msnt
3335: where mtlt.transaction_temp_id = l_transaction_temp_id
3336: and mtlt.lot_number = p_lot
3337: and msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
3338: and p_serial between msnt.fm_serial_number and nvl(msnt.to_serial_number, msnt.fm_serial_number);