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 2886: -- get the next val of mtl_material_transactions_s

2882: END IF;
2883: RETURN(l_return);
2884: END subtract_serials;
2885: --
2886: -- get the next val of mtl_material_transactions_s
2887: FUNCTION next_temp_id RETURN NUMBER IS
2888: CURSOR l_cursor IS SELECT mtl_material_transactions_s.NEXTVAL
2889: FROM dual;
2890: l_temp_id NUMBER;

Line 2888: CURSOR l_cursor IS SELECT mtl_material_transactions_s.NEXTVAL

2884: END subtract_serials;
2885: --
2886: -- get the next val of mtl_material_transactions_s
2887: FUNCTION next_temp_id RETURN NUMBER IS
2888: CURSOR l_cursor IS SELECT mtl_material_transactions_s.NEXTVAL
2889: FROM dual;
2890: l_temp_id NUMBER;
2891: BEGIN
2892: OPEN l_cursor;

Line 3154: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3150: -- ELSE
3151: -- l_qty_sign := -1;
3152: -- END IF;
3153: l_qty_sign := 1;
3154: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3155: INTO l_txn_header_id FROM DUAL;
3156: g_transaction_header_id := l_txn_header_id;
3157: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3158: INTO l_txn_temp_id FROM DUAL;

Line 3157: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3153: l_qty_sign := 1;
3154: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3155: INTO l_txn_header_id FROM DUAL;
3156: g_transaction_header_id := l_txn_header_id;
3157: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3158: INTO l_txn_temp_id FROM DUAL;
3159: IF p_request_context.item_lot_control_code = 2 THEN
3160: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3161: INTO l_serial_temp_id FROM DUAL;

Line 3160: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3156: g_transaction_header_id := l_txn_header_id;
3157: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3158: INTO l_txn_temp_id FROM DUAL;
3159: IF p_request_context.item_lot_control_code = 2 THEN
3160: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3161: INTO l_serial_temp_id FROM DUAL;
3162: END IF;
3163: l_mmtt_tbl_size := 0;
3164: l_mtlt_tbl_size := 0;

Line 3535: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3531: l_sec_lot_temp_qty := 0;
3532: -- see whether we need a new l_serial_temp_id
3533: IF p_request_context.item_serial_control_code IN (2,5,6) THEN
3534: -- get the serial temp id if serial control is yes
3535: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3536: INTO l_serial_temp_id FROM DUAL;
3537: END IF;
3538: END IF;
3539: IF p_request_context.item_lot_control_code = 2 THEN

Line 3554: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

3550: IF l_insert_txn THEN
3551: -- reset the quantity for the next mmtt record
3552: l_txn_temp_qty := 0;
3553: l_sec_txn_temp_qty := 0;
3554: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3555: INTO l_txn_temp_id FROM DUAL;
3556: END IF;
3557: -- accumulate the quantity from g_output_process_tbl(l_index)
3558: -- for the next mmtt record