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_LABEL_PVT10 dependencies on MTL_SERIAL_NUMBERS

Line 577: p_inventory_item_id mtl_serial_numbers.inventory_item_id%TYPE,

573:
574: /*=================================================================*/
575: PROCEDURE get_data_serial(
576: x_out_tbl IN OUT NOCOPY output_tbl_type,
577: p_inventory_item_id mtl_serial_numbers.inventory_item_id%TYPE,
578: p_serial_number mtl_serial_numbers.serial_number%TYPE
579: )IS
580:
581: CURSOR serial_curs IS

Line 578: p_serial_number mtl_serial_numbers.serial_number%TYPE

574: /*=================================================================*/
575: PROCEDURE get_data_serial(
576: x_out_tbl IN OUT NOCOPY output_tbl_type,
577: p_inventory_item_id mtl_serial_numbers.inventory_item_id%TYPE,
578: p_serial_number mtl_serial_numbers.serial_number%TYPE
579: )IS
580:
581: CURSOR serial_curs IS
582: SELECT

Line 642: FROM MTL_SERIAL_NUMBERS serial,

638: serial.time_since_visit,
639: serial.vendor_serial_number,
640: serial.serial_number,
641: serial_status.status_code
642: FROM MTL_SERIAL_NUMBERS serial,
643: MTL_MATERIAL_STATUSES_VL serial_status
644: WHERE serial.inventory_item_id = p_inventory_item_id
645: AND serial.serial_number = p_serial_number
646: AND serial.status_id = serial_status.status_id (+);

Line 1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,

1784: subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE,
1785: locator_id mtl_material_transactions_temp.locator_id%TYPE,
1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,
1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,
1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,
1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,
1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,
1791: project_id mtl_material_transactions_temp.project_id%TYPE,
1792: task_id mtl_material_transactions_temp.task_id%TYPE,

Line 1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,

1785: locator_id mtl_material_transactions_temp.locator_id%TYPE,
1786: lot_number mtl_material_transactions_temp.lot_number%TYPE,
1787: serial_number mtl_material_transactions_temp.serial_number%TYPE,
1788: serial_number_start mtl_serial_numbers.serial_number%TYPE,
1789: serial_number_end mtl_serial_numbers.serial_number%TYPE,
1790: cost_group_id mtl_material_transactions_temp.cost_group_id%TYPE,
1791: project_id mtl_material_transactions_temp.project_id%TYPE,
1792: task_id mtl_material_transactions_temp.task_id%TYPE,
1793: quantity mtl_material_transactions_temp.transaction_quantity%TYPE,

Line 2164: * Currently the cursor is fetching data using mtl_serial_numbers_temp table.

2160: /* The following cursor has been modified for the bug# 5475495
2161: * The cursor will be opened only for LPN- Flow/WorkOrderLess completion Txn's
2162: * ie., transaction_identifier will be 1(i.e., MMTT_TYPE in this PACKAGE)
2163: *
2164: * Currently the cursor is fetching data using mtl_serial_numbers_temp table.
2165: * whereas the data will present only on mtl_serial_numbers table.
2166: * hence, modified the code to retrieve the serial numbers based on lpn_id in
2167: * mtl_material_transactions_temp and lpn_id in mtl_serial_numbers.
2168:

Line 2165: * whereas the data will present only on mtl_serial_numbers table.

2161: * The cursor will be opened only for LPN- Flow/WorkOrderLess completion Txn's
2162: * ie., transaction_identifier will be 1(i.e., MMTT_TYPE in this PACKAGE)
2163: *
2164: * Currently the cursor is fetching data using mtl_serial_numbers_temp table.
2165: * whereas the data will present only on mtl_serial_numbers table.
2166: * hence, modified the code to retrieve the serial numbers based on lpn_id in
2167: * mtl_material_transactions_temp and lpn_id in mtl_serial_numbers.
2168:
2169: -- Bug 2882958, added parameter p_lot_number to restrict on lot

Line 2167: * mtl_material_transactions_temp and lpn_id in mtl_serial_numbers.

2163: *
2164: * Currently the cursor is fetching data using mtl_serial_numbers_temp table.
2165: * whereas the data will present only on mtl_serial_numbers table.
2166: * hence, modified the code to retrieve the serial numbers based on lpn_id in
2167: * mtl_material_transactions_temp and lpn_id in mtl_serial_numbers.
2168:
2169: -- Bug 2882958, added parameter p_lot_number to restrict on lot
2170: CURSOR mmtt_serial_curs(p_lot_number VARCHAR2) IS
2171: -- Serial Control

Line 2174: mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

2170: CURSOR mmtt_serial_curs(p_lot_number VARCHAR2) IS
2171: -- Serial Control
2172: SELECT msn.serial_number
2173: FROM mtl_material_transactions_temp mmtt,
2174: mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
2175: where mmtt.transaction_temp_id = msnt.transaction_temp_id
2176: and msnt.fm_serial_number <= msn.serial_number AND
2177: msnt.to_serial_number >= msn.serial_number
2178: and mmtt.organization_id = msn.current_organization_id

Line 2185: mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

2181: UNION
2182: -- Lot and Serial Control
2183: SELECT msn.serial_number
2184: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt,
2185: mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
2186: where mmtt.transaction_temp_id = mtlt.transaction_temp_id
2187: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
2188: and msnt.fm_serial_number <= msn.serial_number AND
2189: msnt.to_serial_number >= msn.serial_number

Line 2199: mtl_serial_numbers msn

2195:
2196: CURSOR mmtt_serial_curs(p_lot_number VARCHAR2) IS
2197: SELECT msn.serial_number
2198: FROM mtl_material_transactions_temp mmtt,
2199: mtl_serial_numbers msn
2200: where mmtt.transaction_temp_id = l_transaction_id
2201: and (mmtt.lpn_id = msn.lpn_id
2202: or mmtt.content_lpn_id = msn.lpn_id) -- Modified for the bug # 5740354
2203: and mmtt.inventory_item_id = msn.inventory_item_id

Line 2207: mtl_serial_numbers msn

2203: and mmtt.inventory_item_id = msn.inventory_item_id
2204: UNION
2205: SELECT msn.serial_number
2206: FROM mtl_material_transactions_temp mmtt,
2207: mtl_serial_numbers msn
2208: where mmtt.transaction_temp_id = l_transaction_id
2209: and (mmtt.lpn_id = msn.lpn_id
2210: or mmtt.content_lpn_id = msn.lpn_id) -- Modified for the bug # 5740354
2211: and mmtt.inventory_item_id = msn.inventory_item_id

Line 2220: mtl_serial_numbers_interface msni, mtl_serial_numbers msn

2216: CURSOR mti_serial_curs(p_lot_number VARCHAR2) IS
2217: -- Serial Control
2218: SELECT msn.serial_number
2219: FROM mtl_transactions_interface mti,
2220: mtl_serial_numbers_interface msni, mtl_serial_numbers msn
2221: where mti.transaction_interface_id =msni.transaction_interface_id
2222: and msni.fm_serial_number <= msn.serial_number AND
2223: msni.to_serial_number >= msn.serial_number
2224: and mti.organization_id = msn.current_organization_id

Line 2231: mtl_serial_numbers_interface msni, mtl_serial_numbers msn

2227: UNION
2228: -- Lot and Serial Control
2229: SELECT msn.serial_number
2230: FROM mtl_transactions_interface mti, mtl_transaction_lots_interface mtli,
2231: mtl_serial_numbers_interface msni, mtl_serial_numbers msn
2232: where mti.transaction_interface_id = mtli.transaction_interface_id
2233: and mtli.serial_transaction_temp_id = msni.transaction_interface_id
2234: and msni.fm_serial_number <= msn.serial_number AND
2235: msni.to_serial_number >= msn.serial_number

Line 2244: FROM mtl_serial_numbers

2240: and mtli.lot_number = p_lot_number;
2241:
2242: CURSOR serial_curs IS
2243: select serial_number
2244: FROM mtl_serial_numbers
2245: WHERE current_organization_id = l_in_rec.organization_id
2246: AND inventory_item_id = l_in_rec.inventory_item_id
2247: AND current_subinventory_code = l_in_rec.subinventory_code
2248: AND NVL(revision, '@@@@') = NVL(l_in_rec.revision,'@@@@')