DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 101: /* SELECT mtl_material_transactions_s.NEXTVAL

97: v_trxqty := -1 * p_trx_qty;
98: v_priqty := -1 * p_pri_qty;
99: END IF;
100:
101: /* SELECT mtl_material_transactions_s.NEXTVAL
102: INTO x_trx_tmp_id
103: FROM DUAL; */
104:
105: -- If content Item Id is not NULL then set ItemId = -1;

Line 180: nvl(v_trx_hdr_id,mtl_material_transactions_s.NEXTVAL)

176: , ship_to_location --eIB Build; Bug# 4348541
177: , relieve_reservations_flag -- Bug 6310875
178: )
179: VALUES (
180: nvl(v_trx_hdr_id,mtl_material_transactions_s.NEXTVAL)
181: -- , x_trx_tmp_id
182: , mtl_material_transactions_s.NEXTVAL -- Bug 5535030
183: , nvl(p_process_flag,'Y')
184: , SYSDATE

Line 182: , mtl_material_transactions_s.NEXTVAL -- Bug 5535030

178: )
179: VALUES (
180: nvl(v_trx_hdr_id,mtl_material_transactions_s.NEXTVAL)
181: -- , x_trx_tmp_id
182: , mtl_material_transactions_s.NEXTVAL -- Bug 5535030
183: , nvl(p_process_flag,'Y')
184: , SYSDATE
185: , p_user_id
186: , SYSDATE

Line 690: , mtl_material_transactions_s.NEXTVAL

686: , p_secondary_uom
687: , LTRIM(RTRIM(p_lot_number))
688: , p_exp_date
689: -- , x_ser_trx_id
690: , mtl_material_transactions_s.NEXTVAL
691: , NVL(p_description, l_description)
692: , NVL(p_vendor_name, l_vendor_name)
693: , NVL(p_supplier_lot_number, l_supplier_lot_number)
694: , NVL(p_origination_date, l_origination_date)

Line 1404: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL;

1400: END IF;
1401: END IF;
1402:
1403:
1404: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL;
1405:
1406: INSERT INTO mtl_material_transactions_temp(
1407: transaction_header_id
1408: , transaction_temp_id