DBA Data[Home] [Help]

APPS.INV_RCV_STD_TRANSFER_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2794: SELECT mtl_material_transactions_s.NEXTVAL

2790: AND organization_id = p_org_id;
2791:
2792: IF (l_txn_if_id IS NULL) THEN
2793: BEGIN
2794: SELECT mtl_material_transactions_s.NEXTVAL
2795: INTO l_txn_if_id
2796: FROM sys.dual;
2797: EXCEPTION
2798: WHEN OTHERS THEN

Line 3589: select mtl_material_transactions_s.nextval

3585: IF (p_lot_number IS NOT NULL) THEN
3586:
3587: -- Generate the Serial Txn Temp Id
3588:
3589: select mtl_material_transactions_s.nextval
3590: into l_ser_txn_temp_id from dual;
3591:
3592: l_rti_tb(l_txn_id)(l_lot_num).lot_number := l_serial_rec.lot_num;
3593: l_rti_tb(l_txn_id)(l_lot_num).serial_intf_id := l_ser_txn_temp_id;