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_DETAIL_UTIL_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3023: -- get the next val of mtl_material_transactions_s

3019: END IF;
3020: RETURN(l_return);
3021: END subtract_serials;
3022: --
3023: -- get the next val of mtl_material_transactions_s
3024: FUNCTION next_temp_id RETURN NUMBER IS
3025: CURSOR l_cursor IS SELECT mtl_material_transactions_s.NEXTVAL
3026: FROM dual;
3027: l_temp_id NUMBER;

Line 3025: CURSOR l_cursor IS SELECT mtl_material_transactions_s.NEXTVAL

3021: END subtract_serials;
3022: --
3023: -- get the next val of mtl_material_transactions_s
3024: FUNCTION next_temp_id RETURN NUMBER IS
3025: CURSOR l_cursor IS SELECT mtl_material_transactions_s.NEXTVAL
3026: FROM dual;
3027: l_temp_id NUMBER;
3028: BEGIN
3029: OPEN l_cursor;

Line 3320: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3316: -- ELSE
3317: -- l_qty_sign := -1;
3318: -- END IF;
3319: l_qty_sign := 1;
3320: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3321: INTO l_txn_header_id FROM DUAL;
3322: g_transaction_header_id := l_txn_header_id;
3323: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3324: INTO l_txn_temp_id FROM DUAL;

Line 3323: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3319: l_qty_sign := 1;
3320: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3321: INTO l_txn_header_id FROM DUAL;
3322: g_transaction_header_id := l_txn_header_id;
3323: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3324: INTO l_txn_temp_id FROM DUAL;
3325: IF p_request_context.item_lot_control_code = 2 THEN
3326: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3327: INTO l_serial_temp_id FROM DUAL;

Line 3326: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3322: g_transaction_header_id := l_txn_header_id;
3323: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3324: INTO l_txn_temp_id FROM DUAL;
3325: IF p_request_context.item_lot_control_code = 2 THEN
3326: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3327: INTO l_serial_temp_id FROM DUAL;
3328: END IF;
3329: l_mmtt_tbl_size := 0;
3330: l_mtlt_tbl_size := 0;

Line 3954: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3950: l_sec_lot_temp_qty := 0;
3951: -- see whether we need a new l_serial_temp_id
3952: IF p_request_context.item_serial_control_code IN (2,5,6) THEN
3953: -- get the serial temp id if serial control is yes
3954: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3955: INTO l_serial_temp_id FROM DUAL;
3956: END IF;
3957: END IF;
3958: IF p_request_context.item_lot_control_code = 2 THEN

Line 3973: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3969: IF l_insert_txn THEN
3970: -- reset the quantity for the next mmtt record
3971: l_txn_temp_qty := 0;
3972: l_sec_txn_temp_qty := 0;
3973: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3974: INTO l_txn_temp_id FROM DUAL;
3975: END IF;
3976: -- accumulate the quantity from g_output_process_tbl(l_index)
3977: -- for the next mmtt record