DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 182: /* SELECT mtl_material_transactions_s.NEXTVAL

178: v_trxqty := -1 * p_trx_qty;
179: v_priqty := -1 * p_pri_qty;
180: END IF;
181:
182: /* SELECT mtl_material_transactions_s.NEXTVAL
183: INTO x_trx_tmp_id
184: FROM DUAL; */
185:
186: -- If content Item Id is not NULL then set ItemId = -1;

Line 300: nvl(v_trx_hdr_id,mtl_material_transactions_s.NEXTVAL)

296: , to_project_id --bug 12588822
297: , to_task_id --bug 12588822
298: )
299: VALUES (
300: nvl(v_trx_hdr_id,mtl_material_transactions_s.NEXTVAL)
301: -- , x_trx_tmp_id
302: , mtl_material_transactions_s.NEXTVAL -- Bug 5535030
303: , nvl(p_process_flag,'Y')
304: , SYSDATE

Line 302: , mtl_material_transactions_s.NEXTVAL -- Bug 5535030

298: )
299: VALUES (
300: nvl(v_trx_hdr_id,mtl_material_transactions_s.NEXTVAL)
301: -- , x_trx_tmp_id
302: , mtl_material_transactions_s.NEXTVAL -- Bug 5535030
303: , nvl(p_process_flag,'Y')
304: , SYSDATE
305: , p_user_id
306: , SYSDATE

Line 818: , mtl_material_transactions_s.NEXTVAL

814: , p_secondary_uom
815: , LTRIM(RTRIM(p_lot_number))
816: , p_exp_date
817: -- , x_ser_trx_id
818: , mtl_material_transactions_s.NEXTVAL
819: , NVL(p_description, l_description)
820: , NVL(p_vendor_name, l_vendor_name)
821: , NVL(p_supplier_lot_number, l_supplier_lot_number)
822: , NVL(p_origination_date, l_origination_date)

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

1537: (SELECT decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1538: FROM mtl_material_transactions_temp
1539: WHERE transaction_temp_id = p_transaction_temp_id)
1540: AND msi.organization_id = l_organization_id;
1541: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL;
1542:
1543: INSERT INTO mtl_material_transactions_temp(
1544: transaction_header_id
1545: , transaction_temp_id